FW: [CORE] create database bug

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(at)candle(dot)pha(dot)pa(dot)us]
Sent: Monday, January 25, 1999 11:21 AM
To: DGowin(at)avantec(dot)net
Cc: pgsql-core(at)postgreSQL(dot)org; kraken(at)blueriver(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania
19026