Re: pgAdmin3: adding comments to existing tables

Andreas Pflug wrote:
> Terence Kearns wrote:
> 
>> because the interface attempts to "re-submit all" of the properties of 
>> the existing table for alteration, 
> 
> 
> That should not happen at all. There's a lot of effort taken to identify 
> only changes, and submit only these changes.
> 

Oh ok. my mistake. I assumed that after the following:

Using pgAdmin3, I create a table which now looks like...
CREATE TABLE global.users
(  "userCode" varchar(16),  "userId" int4 NOT NULL DEFAULT nextval('seq_userIds'::text),  fname varchar(32) NOT NULL,
lnamevarchar(32),  email varchar(256),  mobile varchar(32),  phone varchar(32),  "orgId" int4,  "selfGroup" int4 NOT
NULL, CONSTRAINT pk_users PRIMARY KEY ("userId"),  CONSTRAINT "unique_userCode" UNIQUE ("userCode")
 
) WITHOUT OIDS;


Then I select the properties panel in pgAdmin3 for this table and enter 
some text in the comment field which is now blank. As a result, I get 
the following error:

ERROR: Adding columns with defaults is not implemented.Add the column, then use ALTER TABLE SET DEFAULT


After doing some more work on another table to fix it, I have another 
theory, this table is broken because the function call used as the 
DEFAULT value for userId will fail. (I've just learned that not keeping 
everything lower-case in postgres tends to "break things" - despite all 
the double quotes used).


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