Can't rename an existnig DB because it doesn't exist???

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Can't rename an existnig DB because it doesn't exist???
Date: 2008-03-12 17:03:13
Message-ID: 0836165E8EE50F40A3DD8F0D871372671D2CF8@azsmsx421.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

V8.2.0 on Linux

Can't rename a db, complains that it doesn't exist. Yet psql -l shows
that it does and I can connect to it ???

mmdcc228_SETUP(120)% psql stdb2 -c "alter database stdb rename to
stdb_tmp"

ERROR: database "stdb" does not exist

mmdcc228_SETUP(121)% psql -l

List of databases

Name | Owner | Encoding

--------------+----------+----------

cells | dfgauthi | UTF8

cells_dev | dfgauthi | UTF8

postgres | dfgauthi | UTF8

stdb | dfgauthi | UTF8

stdb2 | dfgauthi | UTF8

stdb_standby | dfgauthi | UTF8

template0 | dfgauthi | UTF8

template1 | dfgauthi | UTF8

(8 rows)

mmdcc228_SETUP(122)% psql stdb

Welcome to psql 8.2.0, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms

\h for help with SQL commands

\? for help with psql commands

\g or terminate with semicolon to execute query

\q to quit

stdb=#

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-03-12 17:04:11 Re: ERROR: text search configuration "pg_catalog.english" does not exist
Previous Message Tim Child 2008-03-12 16:53:23 Re: ERROR: text search configuration "pg_catalog.english" does not exist