Thread: comment on constraint
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°
Andreas Kretschmer <akretschmer@spamfence.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
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@momjian.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. +