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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgadmin-support by date

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