Skip site navigation (1) Skip section navigation (2)

Re: pgAdmin3: adding comments to existing tables

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Terence Kearns <terencek(at)isd(dot)canberra(dot)edu(dot)au>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: pgAdmin3: adding comments to existing tables
Date: 2003-07-16 08:58:52
Message-ID: 3F1513CC.2010208@pse-consulting.de (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2003-07-16 09:17:53
Subject: FW: pgAdmin3: adding comments to existing tables
Previous:From: Terence KearnsDate: 2003-07-16 08:52:28
Subject: minor bug in pgAdmin3 when creating views

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group