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: | 20020716123307.GA32203@mail.librelogiciel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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;
DROP DATABASE
template1=# \connect romans
FATAL 1: Database "romans" does not exist in the system catalog.
Previous connection kept
template1=# create database romans;
CREATE DATABASE
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)
romans=#
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2002-07-16 12:41:23 | Bug #712: Documentation Section 3.4 Binary Strings |
Previous Message | ad966 | 2002-07-16 12:08:57 | pgDataRead |