Обсуждение: FW: pgAdmin3: adding comments to existing tables

Hi Andreas,

This is a little worrying - I just tried it here and when trying to set
a comment on a table, what it actually executed was:

ALTER TABLE fig.test ADD COLUMN fooCol fig.foo_domain;
ALTER TABLE fig.test ADD COLUMN myFatCol int4[];
ALTER TABLE fig.test DROP COLUMN "fooCol";
ALTER TABLE fig.test DROP COLUMN "myFatCol";

Which appeared to fail without error. Also, selecting a column and
clicking Change does nothing.

The table defn was:

CREATE TABLE fig.test
( foocol fig.foo_domain, myfatcol int4[]
) WITH OIDS;


Regards, Dave.

> -----Original Message-----
> From: Terence Kearns [mailto:terencek@isd.canberra.edu.au]
> Sent: 16 July 2003 03:33
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] pgAdmin3: adding comments to
> existing tables
>
>
> because the interface attempts to "re-submit all" of the
> properties of
> the existing table for alteration, if you want to change any one
> property of a table, you need to re-apply all properties.
> This has the
> undesired side-effect of failing *any* modification to a
> table if any of
> the other *existing* properties fail to qualify for
> re-applying through
> ALTERing.
>
> For instance, I have a table containing a column with a default value.
>
> When I try to use pgAdmin3 to add(modify) a(the) comment to
> that table,
> the operation fails with the message.
>
> ERROR: Adding columns with defaults is not implementd...
>
> This is silly bacause my intent was not to add a column. I think this
> may be a user-interface design limitation.
>
> --
> Terence Kearns ~ ph: +61 2 6201 5516
> IT Database/Applications Developer
> Enterprise Information Systems
> Client Services Division
> University of Canberra
> www.canberra.edu.au
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

Dave Page wrote:

>Hi Andreas,
>
>This is a little worrying - I just tried it here and when trying to set
>a comment on a table, what it actually executed was:
>
>ALTER TABLE fig.test ADD COLUMN fooCol fig.foo_domain;
>ALTER TABLE fig.test ADD COLUMN myFatCol int4[];
>ALTER TABLE fig.test DROP COLUMN "fooCol";
>ALTER TABLE fig.test DROP COLUMN "myFatCol";
>
OK, took quite a while until I understood what's going on. qtIdent was 
missing on the column name, and fooCol is not the same as "fooCol" so 
the mechanism to determine if a column definition is already present 
didn't hit.

>Also, selecting a column and clicking Change does nothing.
>
Not implemented...

Regards,
Andreas

Andreas Pflug wrote:
> and fooCol is not the same as "fooCol" 

What is the deal with this anyway? Everytime I specify an object name 
with mixed case it decides to throw double quotes around it.

Also, I created a schema called global (no mixed case) and now 
pgAdminIII refers to all objects in this schema as "global".objectname

--
Terence Kearns ~ ph: +61 2 6201 5516
IT Database/Applications Developer
Enterprise Information Systems
Client Services Division
University of Canberra
www.canberra.edu.au