The following bug has been logged online:
Bug reference: 1144
Logged by: comments on database
Email address: Oliver303@aon.at
PostgreSQL version: 7.4
Operating system: Freebsd 4.9-RELEASE
Description: comments don't get propagated
Details:
My system:
`uname -r`: 4.9-RELEASE-p3
postgres version
==> select version(): PostgreSQL 7.4.2 on i386-portbld-freebsd4.9,
compiled by GCC 2.95.4
actually it's not a bug, but it's not a feature, definitely. ;-)
I did a "create database testdb" from psql without a file ${HOME}/.pgsqlrc.
The initial database was "template1". Then i tried a "comment on database
testdb is '...';"
==> cannot create comment
--> I'm using LC_ALL=de_AT.ISO8859-15
translated: database comments can be applied to current database only
so I did a "\c testdb"
and then "comment on database testdb is '...';"
success!
but after "\c tempalte1"
"\l+" doesn't give the comment on testdb.
probably the fact is that pg_database is the same across a cluster, but
pg_catalog.pg_description is not.
After I did a "\c testdb" i saw the the comment.
The docu says that pg_catalog.pg_database is shared between the cluster.
Probably the same should be true for pg_description, since all oid are
unique across the cluster. ?!
In my opinion this fact could confuse some people.
BTW:
Could You give an example of an insert statement to pg_description to
circumvent this inconvenience.
thnx Oliver