create database that already exists.
От | Merlin Moncure |
---|---|
Тема | create database that already exists. |
Дата | |
Msg-id | 303E00EBDD07B943924382E153890E5434A9EF@cuthbert.rcsinc.local обсуждение исходный текст |
Ответы |
Re: create database that already exists.
|
Список | pgsql-hackers |
Here is a verbatim readout of my typing commands into the database shell. I issued a 'create database' to pg 7.4b2 and it did not fail despite an already existing database with the same name. Just thought I'd pass it along, I haven't been able to reproduce it. Just thought I'd pass it along... Merlin [shell log follows] C:\Projects\dbmanager>psql -h linux_server esp Welcome to psql 7.3.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit esp=# create database test; CREATE DATABASE esp=# \c test You are now connected to database test. test=# create table t1(id int, f1 text, f2 text); CREATE TABLE test=# create table t2(id int, f1 text, f2 text); CREATE TABLE test=# \d List of relationsSchema | Name | Type | Owner --------+--------------------+----------+----------------public | cuid_sequence | sequence | postgrespublic | t1 | table | Merlin.Moncurepublic | t2 | table | Merlin.Moncurepublic | xfd_field | table | postgrespublic | xfd_field_key_link | table | postgrespublic | xfd_file | table | postgrespublic| xfd_key | table | postgres (7 rows) test=# create database test; ERROR: database "test" already exists test=# \c esp You are now connected to database esp. esp=# create database test; ERROR: database "test" already exists esp=# select version(); version ------------------------------------------------------------------------ ---------------------------- ---PostgreSQL 7.4beta2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 (Mandrake Linux 9.0 3.2-1md k) (1 row) esp=#
В списке pgsql-hackers по дате отправления: