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

createdb comments

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: createdb comments
Date: 2002-05-01 22:10:13
Message-ID: Pine.LNX.4.21.0205012304230.9945-100000@ponder.fairway2k.co.uk (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general

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


Responses

pgsql-bugs by date

Next:From: R RavishankarDate: 2002-05-02 04:51:28
Subject: Re: Bug #651: Time difference of 30 in while reading in timestamp
Previous:From: Edward PilipczukDate: 2002-05-01 05:25:55
Subject: Re: Bug #640: ECPG: inserting float numbers

pgsql-general by date

Next:From: Neil ConwayDate: 2002-05-01 22:12:40
Subject: Re: aggregate on zero rows slow?
Previous:From: postgresDate: 2002-05-01 21:52:47
Subject: Re: What popular, large commercial websites run

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