Port Bug Report: "drop database DBNAME;" command has critical bug!!! - Mailing list pgsql-ports

From Unprivileged user
Subject Port Bug Report: "drop database DBNAME;" command has critical bug!!!
Date
Msg-id 199905270717.DAA50553@hub.org
Whole thread Raw
List pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : KiBaek Jeong
Your email address      : hannoory@chollian.net

Category                : runtime: back-end
Severity                : critical

Summary: "drop database DBNAME;" command has critical bug!!!

System Configuration
--------------------
  Operating System   : Solaris 2.5.1

  PostgreSQL version : 6.4.2

  Compiler used      : gcc 2.8.1

Hardware:
---------
SunOS main 5.5.1 Generic_103640-12 sun4u sparc SUNW,Ultra-1

Versions of other tools:
------------------------
GNU Make version 3.77
flex version 2.5.4

--------------------------------------------------------------------------

Problem Description:
--------------------
0. psql template1
1. create database hahaha;
2. \c hahaha
3. create table xxx (i int, c char(30), content text);
4. \c template1
5. DROP DATABASE hahaha;
THEN...
6. CREATE DATABASE hahaha;
And THEN, I hope "hahaha" database don't have any tables.
But type \d then, newly "hahaha" database has
previous "xxx" table!!!!!
It's critical error to me.
At this period, if I try to delete this strange xxx table,
then backend prints "ERROR1" -> Message is
"ERROR:  cannot find attribute 1 of relation xxx"
For solving the problem... I must kill my postmaster server.
Then error is cleared.(xxx table is cleared)
But there is still this entire problems... Please help me.


--------------------------------------------------------------------------

Test Case:
----------
0. psql template1
1. create database hahaha;
2. \c hahaha
3. create table xxx (i int, c char(30), content text);
4. \c template1
5. DROP DATABASE hahaha;
THEN...
6. CREATE DATABASE hahaha;
7. \c hahaha
8. \d
   EXIST!, xxx table!!! it's error!
9. select * from xxx;
   THEN, ERROR:  cannot find attribute 1 of relation xxx


--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------


pgsql-ports by date:

Previous
From: Keith Parks
Date:
Subject: Re: [PORTS] Port Bug Report: After creating a rule it is not possible to read the rule by pg_dump or select * from pg_rules
Next
From: "Richard Buechter"
Date:
Subject: Installing PostgreSQL 6.4.2 on SGI Irix6.2