From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | create database that already exists. |
Date: | 2003-10-14 17:58:24 |
Message-ID: | 303E00EBDD07B943924382E153890E5434A9EF@cuthbert.rcsinc.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 relations
Schema | Name | Type | Owner
--------+--------------------+----------+----------------
public | cuid_sequence | sequence | postgres
public | t1 | table | Merlin.Moncure
public | t2 | table | Merlin.Moncure
public | xfd_field | table | postgres
public | xfd_field_key_link | table | postgres
public | xfd_file | table | postgres
public | 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=#
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Karppinen | 2003-10-14 18:02:45 | Re: [PERFORM] Sun performance - Major discovery! |
Previous Message | Andrew Dunstan | 2003-10-14 17:53:19 | Re: fix for strict-alias warnings |