[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?
On Tue, 11 Jun 2002, Bruce Momjian wrote:
>
> The following patch [somehow lost by pine in my reply] fixes the
> problem. Applied.
>
> ---------------------------------------------------------------------------
>
> Nigel J. Andrews wrote:
> >
> >
> > Head of development branch (7.3devel) has a problem applying a comment to a
> > database at the sametime as the database is created using the createdb
> > utility.
> >
> > The error message states the problem:
> >
> > pgsql-current-test$ createdb testdb Test
> > CREATE DATABASE
> > ERROR: Database comments may only be applied to the current database
> > createdb: comment creation failed (database was created)
> >
> > The database is created but the comment does indeed fail for the reason given,
> > as illustrated by:
> >
> > template1=# \c template1
> > You are now connected to database template1.
> > template1=# comment on database testdb is 'Test';
> > ERROR: Database comments may only be applied to the current database
> > template1=# \c testdb
> > You are now connected to database testdb.
> > testdb=# comment on database testdb is 'Test';
> > COMMENT
> >
> > Sorry if this isn't news.
> >
> >
> > --
> > Nigel J. Andrews
>
--
Nigel J. Andrews
Director
---
Logictree Systems Limited
Computer Consultants