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=#
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 |