Re: FW: pgAdmin3: adding comments to existing tables

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: FW: pgAdmin3: adding comments to existing tables
Дата
Msg-id 03AF4E498C591348A42FC93DEA9661B844B300@mail.vale-housing.co.uk
обсуждение исходный текст
Ответы Re: FW: pgAdmin3: adding comments to existing tables  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список pgadmin-support

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: 16 July 2003 11:47
> To: Dave Page
> Cc: pgadmin-support@postgresql.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.


В списке pgadmin-support по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: pgAdmin III Screenshots
Следующее
От: Raymond Chui
Дата:
Сообщение: Timestamp problem