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

Re: FW: pgAdmin3: adding comments to existing tables

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: FW: pgAdmin3: adding comments to existing tables
Date: 2003-07-16 10:47:11
Message-ID: 3F152D2F.40807@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
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


In response to

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2003-07-16 11:19:23
Subject: Re: FW: pgAdmin3: adding comments to existing tables
Previous:From: Dave PageDate: 2003-07-16 09:17:53
Subject: FW: pgAdmin3: adding comments to existing tables

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