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