drop database doesn't work
От | Jerome Alet |
---|---|
Тема | drop database doesn't work |
Дата | |
Msg-id | 20020716123307.GA32203@mail.librelogiciel.com обсуждение исходный текст |
Ответы |
Re: drop database doesn't work
|
Список | pgsql-bugs |
============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : Jerome Alet Your email address : alet@librelogiciel.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: ---------------------------------------------------------------------
В списке pgsql-bugs по дате отправления: