FW: [CORE] create database bug - Mailing list pgsql-hackers

From Dan Gowin
Subject FW: [CORE] create database bug
Date
Msg-id 43A3A1806104D211988500A0C9B576EE7CE230@avantec_exc.avantec.net
Whole thread Raw
Responses Re: [HACKERS] FW: [CORE] create database bug
List pgsql-hackers
I've got the bug working on Sparc Linux also. Don't understand why
you can't recreate it.

D.

-----Original Message-----
From: Bruce Momjian [mailto:maillist@candle.pha.pa.us] 
Sent: Monday, January 25, 1999 11:21 AM
To: DGowin@avantec.net
Cc: pgsql-core@postgreSQL.org; kraken@blueriver.net
Subject: Re: [CORE] create database bug


> All,
>     If you create a database with "_" in the name some strange
> things
> occur. For example:
> 
> 1)    create database cfg_smb;
>         ok
> 2)    drop database cfg_smb;
>         ok
> 3)    create database cfg_smb;
>         error: database already exists.
> 4)    drop database cfg_smb;
>         error: database does not exist.
>     (Note: the database directory still exists, but no files are
> within it.)
> 
> But on the other hand:
> 
> 1)    create database cfgsmb;
>         ok
> 2)    drop database cfgsmb;
>         ok
> 3)    create database cfgsmb;
>         ok
> 4)    drop database cfgsmb;
>         ok
> 
>     Everything is fine.
> 
> I don't know where the code is that handles the dropping of databases,
> but I would
> think this would be easy to fix. 
> 
> Versions this was tried on:
> PostgreSQL v6.4, PostgreSQL v6.4.1, PostgreSQL v6.4.2
> Red Hat Linux v5.2, Intel Pentium II 300 MHz

Can't recreate the problem here on bsdi and current development sources.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania
19026


pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Re: datetime regress test busted by incomplete checkin
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] FW: [CORE] create database bug