Обсуждение: 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. -- 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
> > 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) #