Re: FW: pgAdmin3: adding comments to existing tables

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin(at)pse-consulting(dot)de]
> Sent: 16 July 2003 11:47
> To: Dave Page
> Cc: pgadmin-support(at)postgresql(dot)org
> Subject: Re: FW: [pgadmin-support] pgAdmin3: adding comments
> to existing tables
>
>
> 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.

Looks OK now, though the definition pane needs a refresh to see the
changes.

> >Also, selecting a column and clicking Change does nothing.
> >
> Not implemented...

OK.