Can't rename an existnig DB because it doesn't exist???
От | Gauthier, Dave |
---|---|
Тема | Can't rename an existnig DB because it doesn't exist??? |
Дата | |
Msg-id | 0836165E8EE50F40A3DD8F0D871372671D2CF8@azsmsx421.amr.corp.intel.com обсуждение исходный текст |
Ответы |
Re: Can't rename an existnig DB because it doesn't exist???
|
Список | 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=#
В списке pgsql-general по дате отправления: