RE: [HACKERS] FW: [CORE] create database bug

I'll recheck everything tonight and recompile with the latest
source on a fresh Red Hat machine.

D.

-----Original Message-----
From: jwieck(at)debis(dot)com [mailto:jwieck(at)debis(dot)com]
Sent: Monday, January 25, 1999 1:33 PM
To: DGowin(at)avantec(dot)net
Cc: pgsql-core(at)postgreSQL(dot)org; pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] 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.

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(at)debis(dot)com (Jan Wieck) #