COMMENT ON DATABASE db IS 'Comment';

Now switch databases.  Comment is gone.

Of course, adding the comments to template1 will carry comments
forward (in pg_description) to future DBs.  Not fatal, but quite
annoying.

I suppose in order to add a comment field to pg_database it would need
to be toasted or something (ton of work).  Any other way to fix this?
--
Rod


Fri, 19 Apr 2002 14:01:16 -0400
"Rod Taylor" <rbt@zort.ca>
Really annoying comments...
"Rod Taylor" <rbt@zort.ca> writes:
> COMMENT ON DATABASE db IS 'Comment';
> Now switch databases.  Comment is gone.

Yeah, it's not very helpful.  I'm not sure why we bothered to implement
that in the first place.

> I suppose in order to add a comment field to pg_database it would need
> to be toasted or something (ton of work).  Any other way to fix this?

I'm more inclined to rip it out ;-).  I don't think it's worth the
trouble.  Keeping database comments someplace else than pg_description
is certainly *not* the way to go --- everything that reads them would
have to be tweaked too.

What does need to be added at the moment is COMMENT ON SCHEMA (a/k/a
namespace).

			regards, tom lane

Fri, 19 Apr 2002 14:53:49 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Really annoying comments... 