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) #

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

D.

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

Dan Gowin <DGowin@avantec.net> writes:

If you create a database with "_" in the name some strange
things occur.

I don't see this bug either.

Are you perhaps running with non-English locale settings?
That might make a difference...

regards, tom lane