Skip site navigation (1) Skip section navigation (2)

Port Bug Report: "drop database DBNAME;" command has critical bug!!!

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: "drop database DBNAME;" command has critical bug!!!
Date: 1999-05-27 07:17:28
Message-ID: 199905270717.DAA50553@hub.org (view raw or flat)
Thread:
Lists: pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : KiBaek Jeong
Your email address      : hannoory(at)chollian(dot)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:
---------


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


Responses

pgsql-ports by date

Next:From: Richard BuechterDate: 1999-05-27 10:42:20
Subject: Installing PostgreSQL 6.4.2 on SGI Irix6.2
Previous:From: Keith ParksDate: 1999-05-26 20:55:42
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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group