Обсуждение: Database Comments

Hi,

Using COMMENT ON DATABASE only allows you to create a comment
for your current database which is then only visible from that database.
However, if I manually insert appropriate values into pg_description
in other databases I can make comments appear for another database.

e.g. If some users have access to databases A,B&C, I can insert
values so that the users can see descriptions for each database
from any of them.

Is it safe to do this, or can it have unexpected side effects?


Also is there any intention to have a 'COMMENT ON [ROLE|USER|GROUP]'
facility. It would be quite useful to be able to do something like

COMMENT ON USER jbloggs IS 'Joe Bloggs <j.bloggs@foo.bar>'

    -Mark

Mark Rae <mrae@purplebat.com> writes:
> Using COMMENT ON DATABASE only allows you to create a comment
> for your current database which is then only visible from that database.
> ...
> Also is there any intention to have a 'COMMENT ON [ROLE|USER|GROUP]'
> facility.

There's been some discussion of creating a shared catalog for comments
on shared objects, which would let us fix the current bogus behavior
of COMMENT ON DATABASE and add comments on users/etc that weren't
equally bogus.  Nobody's stepped up to make it happen though.

            regards, tom lane