From: | "Natalya Makushina" <mak(at)rtsoft(dot)msk(dot)ru> |
---|---|
To: | <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Can not destroy db |
Date: | 1999-12-24 13:19:27 |
Message-ID: | 003f01bf4e11$814e5bf0$31c8a8c0@makushina.rtsoft.msk.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello all!
I found very strange thing.
I have database "wwwnews". It have 4 tables, indexes and triggers. I destroy this database and create it again. All work okey.
Then i say
psql wwwnews
To my great surprise I saw all tables with information.
I repeat this sequence of command few times. Result is a same.
I try to create another database. I create it and this database have 4 tables too!
What do I do wrong?
Postgres version: 6.5.2.
Platform: Red Hat Linux release 5.0 (Hurricane) Kernel 2.1.57 on a ppc
Best regards, Natalya Makushina.
$psql wwwnews
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.2 on powerpc-unknown-linux-gnu, compiled by gcc egcs-2.90.25 980302 (egcs-1.0.2 prer
elease)]
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: wwwnews
wwwnews=> \dt
Database = wwwnews
+------------------+----------------------------------+----------+
| Owner | Relation | Type |
+------------------+----------------------------------+----------+
| mak | exibition | table |
| mak | id | table |
| mak | information | table |
| mak | news | table |
| mak | seminar | table |
+------------------+----------------------------------+----------+
wwwnews=> \q
$ destroydb wwwnews
$ psql wwwnews
Connection to database 'wwwnews' failed.
FATAL 1: Database wwwnews does not exist in pg_database
$ createdb wwwnews
$ psql wwwnews
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.2 on powerpc-unknown-linux-gnu, compiled by gcc egcs-2.90.25 980302 (egcs-1.0.2 prer
elease)]
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: wwwnews
wwwnews=> \dt
Database = wwwnews
+------------------+----------------------------------+----------+
| Owner | Relation | Type |
+------------------+----------------------------------+----------+
| mak | exibition | table |
| mak | id | table |
| mak | information | table |
| mak | news | table |
| mak | seminar | table |
+------------------+----------------------------------+----------+
wwwnews=> \q
$ createdb wwwnews1
$ psql wwwnews1
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.2 on powerpc-unknown-linux-gnu, compiled by gcc egcs-2.90.25 980302 (egcs-1.0.2 prer
elease)]
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: wwwnews1
wwwnews1=> \dt
Database = wwwnews1
+------------------+----------------------------------+----------+
| Owner | Relation | Type |
+------------------+----------------------------------+----------+
| mak | exibition | table |
| mak | id | table |
| mak | information | table |
| mak | news | table |
| mak | seminar | table |
+------------------+----------------------------------+----------+
wwwnews1=> \q
$
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Mercer | 1999-12-24 16:53:17 | proctitle patch (useful) |
Previous Message | J. Roeleveld | 1999-12-24 10:58:41 | HELP, receiving error-message (follow-up) |