Re: [BUGS] createdb comments

Nigel J. Andrews wrote:
>
>
> [I've changed the list to -general from -bugs. I hope that's acceptable]
>
>
> Thanks Bruce,
>
> If I'd realised createdb was that simple I'd have done it myself. However, I
> think I was locked into the idea that the SQL command should work as well.
>
> I'm afraid I don't know the standard but from the command I would assume that
> the COMMENT ON DATABASE was intended to work on any database from any
> database. Is that incorrect, possibly because of security concerns?

No, it can't because pg_description is per-database, while pg_database
is global to all databases.  No way to handle this because we can't
update every pg_description in every database.  We could update just
template1's pg_description, but only the super-user can do that.  What
we do is to just update the datbase description stored in the current
database.


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026