Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

In response to

Responses

pgsql-bugs by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group