Обсуждение: Bug #736: Old bug is back!! Drop database bug

Chester Chee (cchee@direcInternet.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Old bug is back!! Drop database bug

Long Description
PostgreSQL version 7.2.1 running on RedHat 7.3 with all the latest patches installed.

Step to reproduce the problem:
0) create database junk;
1) create table more_junk ....;
2) drop database junk;
3) create database junk;
4) I am expecting to see database junk do not have any tables, but if list the tables... all the previous tables are
backwith data in it!! 







Sample Code


No file was uploaded with this report

pgsql-bugs@postgresql.org wrote:
 > Chester Chee (cchee@direcInternet.com) reports a bug with a severity
 > of 2 The lower the number the more severe it is.
 >
 > Short Description Old bug is back!! Drop database bug
 >
 > Long Description PostgreSQL version 7.2.1 running on RedHat 7.3 with
 > all the latest patches installed.
 >
 > Step to reproduce the problem: 0) create database junk; 1) create
 > table more_junk ....; 2) drop database junk; 3) create database junk;
 >  4) I am expecting to see database junk do not have any tables, but
 > if list the tables... all the previous tables are back with data in
 > it!!

Try connecting to the template1 database, and then do \dt. Do you see
the tables in question?

Joe