Lists: | pgsql-general |
---|
From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | comment on constraint |
Date: | 2009-09-04 14:45:44 |
Message-ID: | 20090904144544.GA8429@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Hi,
There is a question in the german pg-forum:
It is possible to add a comment on a constraint, but \dd doesn't display
that comment. There is also a old question in this mailing-list without
an answer:
http://archives.postgresql.org/pgsql-general/2003-07/msg01448.php
I think, this is a bug, isn't it?
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
From: | Tim Landscheidt <tim(at)tim-landscheidt(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: comment on constraint |
Date: | 2009-09-04 15:38:58 |
Message-ID: | m3d466vhwt.fsf@passepartout.tim-landscheidt.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Andreas Kretschmer <akretschmer(at)spamfence(dot)net> wrote:
> There is a question in the german pg-forum:
> It is possible to add a comment on a constraint, but \dd doesn't display
> that comment. There is also a old question in this mailing-list without
> an answer:
> http://archives.postgresql.org/pgsql-general/2003-07/msg01448.php
> I think, this is a bug, isn't it?
Why? The man page for psql clearly says:
| \dd[S] [ pattern ]
| Shows the descriptions of objects matching the
| pattern, or of all visible objects if no argu-
| ment is given. But in either case, only objects
| that have a description are listed. By default,
| only user-created objects are shown; supply a
| pattern or the S modifier to include system ob-
| jects. ‘‘Object’’ covers aggregates, functions,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| operators, types, relations (tables, views, in-
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| dexes, sequences), large objects, rules, and
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| triggers. [...]
^^^^^^^^^
So no comments are shown for constraints or table columns
or ...
Tim
From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: comment on constraint |
Date: | 2010-02-23 05:31:27 |
Message-ID: | 201002230531.o1N5VR507932@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Andreas Kretschmer wrote:
> Hi,
>
> There is a question in the german pg-forum:
>
> It is possible to add a comment on a constraint, but \dd doesn't display
> that comment. There is also a old question in this mailing-list without
> an answer:
> http://archives.postgresql.org/pgsql-general/2003-07/msg01448.php
>
> I think, this is a bug, isn't it?
Yep, added to TODO:
Allow \dd to show constraint comments
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do
+ If your life is a hard drive, Christ can be your backup. +