Re: pgAdmin3: adding comments to existing tables - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: pgAdmin3: adding comments to existing tables
Date
Msg-id 3F1513CC.2010208@pse-consulting.de
Whole thread Raw
In response to pgAdmin3: adding comments to existing tables  (Terence Kearns <terencek@isd.canberra.edu.au>)
Responses Re: pgAdmin3: adding comments to existing tables
List pgadmin-support
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.

> 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. 

Please state exactly what you are doing, because what you're describing 
here shouldn't happen at all.

Regards,
Andreas



pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: FW: pgAdmin3: adding comments to existing tables
Next
From: D Tim Cummings
Date:
Subject: Re: Migration Wizard - Access 97 Autonumber