Re: comments on columns aren't displayed by \dd

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: comments on columns aren't displayed by \dd
Дата
Msg-id 200103200523.AAA27697@candle.pha.pa.us
обсуждение исходный текст
Ответ на comments on columns aren't displayed by \dd  (pgsql-bugs@postgresql.org)
Ответы Re: comments on columns aren't displayed by \dd  (Stephen van Egmond <svanegmond@bang.dhs.org>)
Список pgsql-bugs
Psql manual pages says:

              The command form \d+ is identical, but any comments
              associated  with  the  table  columns  are shown as
              well.

> Stephen van Egmond (svanegmond@home.com) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> comments on columns aren't displayed by \dd
>
> Long Description
> Comments on columns appear to be broken.  CREATE COMMENT ON COLUMN inserts stuff into the backend pg_* tables
correctly. However \dd from the psql interactive monitor doesn't send a query to retrieve it (i.e. no join on
pg_attribute).
>
> I am working from the Debian package postgresql-client 7.0.3-2.
>
> Sample Code
> create table foo (a text);
> cmment on column foo.a is 'hello!';
> \dd foo.a
>
> No file was uploaded with this report
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

Предыдущее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: comments on columns aren't displayed by \dd
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: comments on columns aren't displayed by \dd