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

Mon, 25 Jan 1999 12:06:37 -0500
Dan Gowin <DGowin@avantec.net>
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@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.

    I can't too here on i486-pc-linux-gnu and current development
    tree.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #



Mon, 25 Jan 1999 19:33:07 +0100 (MET)
jwieck@debis.com (Jan Wieck)
Re: [HACKERS] FW: [CORE] create database bug