Can not destroy db

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
$

Browse pgsql-general by date

  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)