Re: Comments on Database Broken

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: pholben@greatbridge.com, pgsql-bugs@postgresql.org
Date: 2001-05-21T19:09:41Z
Lists: pgsql-bugs
pgsql-bugs@postgresql.org writes:
> When comments are added to a database (testdb in this example) (either
> at the point of creation or using the "comment on database ..."
> command) they may be stored either at the system level or within the
> individual database storage area.

There is no such thing as comments "stored at the system level".
Comments live in pg_description which is a per-database table.
I think you are confusing the behavior of comments stored in template1
(which will get copied to subsequently-created databases) with a
true installation-wide table.

We could theoretically answer this by making a pg_global_description
table that is installation-wide like pg_database, but I'm not convinced
that it's worth worrying about.  I'm not even convinced that the
behavior is wrong: why shouldn't each DB be able to have its own comment
on the other DBs?

			regards, tom lane