Skip site navigation (1) Skip section navigation (2)

drop database doesn't work

From: Jerome Alet <alet(at)librelogiciel(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: drop database doesn't work
Date: 2002-07-16 12:33:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
                        POSTGRESQL BUG REPORT TEMPLATE

Your name               : Jerome Alet
Your email address      : alet(at)librelogiciel(dot)com

System Configuration
  Architecture (example: Intel Pentium)         : Intel Pentium II

  Operating System (example: Linux 2.0.26 ELF)  : Linux 2.4.18 ELF ext3fs

  PostgreSQL version (example: PostgreSQL-7.2.1):   PostgreSQL-7.2.1 (Debian Sid)

  Compiler used (example:  gcc 2.95.2)          : 

Please enter a FULL description of your problem:

drop database doesn't really drop it.
if I drop a database and recreate a new one with the
same name, the old datas and base schema are still there
to annoy me.

Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 

Here's a sample psql session which shows the problem :

romans=# \connect template1 postgres
You are now connected to database template1 as user postgres.
template1=# drop database romans;
template1=# \connect romans
FATAL 1:  Database "romans" does not exist in the system catalog.
Previous connection kept
template1=# create database romans;
template1=# \connect romans postgres
You are now connected to database romans as user postgres.
romans=# \d
            List of relations
       Name        |   Type   |  Owner
auteurs           | table    | postgres
auteurs_id_seq    | sequence | postgres
(15 rows)


If you know how this problem might be fixed, list the solution below:


pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-07-16 12:41:23
Subject: Bug #712: Documentation Section 3.4 Binary Strings
Previous:From: ad966Date: 2002-07-16 12:08:57
Subject: pgDataRead

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group