BUG #1143: comments don't get propagated

The following bug has been logged online:

Bug reference:      1143
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