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
|
Список | 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 по дате отправления: