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

From Andreas Pflug
Subject Re: FW: pgAdmin3: adding comments to existing tables
Date
Msg-id 3F152D2F.40807@pse-consulting.de
Whole thread Raw
In response to FW: pgAdmin3: adding comments to existing tables  ("Dave Page" <dpage@vale-housing.co.uk>)
Responses double quoted object names  (Terence Kearns <terencek@isd.canberra.edu.au>)
List 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



pgadmin-support by date:

Previous
From: Terence Kearns
Date:
Subject: minor bug in pgAdmin3 when creating views
Next
From: "Dave Page"
Date:
Subject: Re: BUG: pgAdmin III View table with empty strings