Re: createdb comments

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: createdb comments
Date: 2002-06-11 22:20:41
Message-ID: 200206112220.g5BMKgx23147@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general


The following patch 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
> Director
>
> ---
> Logictree Systems Limited
> Computer Consultants
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

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

Attachment Content-Type Size
unknown_filename text/plain 888 bytes

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Enke, Michael 2002-06-12 07:48:18 Re: [HACKERS] Bug #659: lower()/upper() bug on
Previous Message Bruce Momjian 2002-06-11 21:33:57 Re: Bug #690: pg_ctl doesn't act properly for option -w

Browse pgsql-general by date

  From Date Subject
Next Message Ron Snyder 2002-06-11 22:37:29 Re: Poor performance in Porting Oracle based applicatio
Previous Message Ray Hunter 2002-06-11 22:17:12 PostGIS