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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pgDataRead
Следующее
От: Joe Conway
Дата:
Сообщение: Re: Bug #712: Documentation Section 3.4 Binary Strings