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
) WITH OIDS;
> -----Original Message-----
> From: Terence Kearns [mailto:terencek(at)isd(dot)canberra(dot)edu(dot)au]
> Sent: 16 July 2003 03:33
> To: pgadmin-support(at)postgresql(dot)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
> 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
> ---------------------------(end of
> TIP 4: Don't 'kill -9' the postmaster
pgadmin-support by date
|Next:||From: Andreas Pflug||Date: 2003-07-16 10:47:11|
|Subject: Re: FW: pgAdmin3: adding comments to existing tables|
|Previous:||From: Andreas Pflug||Date: 2003-07-16 08:58:52|
|Subject: Re: pgAdmin3: adding comments to existing tables|