-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


The problem:

	Creating a table with a name containing mixed case that has a
	constraint, the creation will fail.  For example:

	    mug=> create table "MyTest" ( a int4 default 10 );
	    ERROR:  mytest: Table does not exist.
	    mug=> 

The Solution:

	I haven't the faintest idea!

This problem bit me when I was trying to move an MS-Access database to 
postgreSQL while keeping MS-Access as the front end for the database.
- -- 
____       | Billy G. Allie    | Domain....: Bill.Allie@mug.org
|  /|      | 7436 Hartwell     | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie@email.msn.com
|/  |LLIE  | (313) 582-1540    | 



-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 5.0i for non-commercial use
Charset: noconv

iQA/AwUBNkpoxaFebSRz8o+3EQI+rwCdH1luSaOd78t0fKax+G4JnDeNndcAoKFV
QfKhqQuqVhRYPYFUTBpCDwBD
=KaAB
-----END PGP SIGNATURE-----


Wed, 11 Nov 1998 23:49:10 -0500
"Billy G. Allie" <Bill.Allie@mug.org>
A problem with the constraint system.
Hello Billy,

giovedï¿½, 12 novembre 98, you wrote:

BGA> -----BEGIN PGP SIGNED MESSAGE-----
BGA> Hash: SHA1


BGA> The problem:

BGA>         Creating a table with a name containing mixed case that has a
BGA>         constraint, the creation will fail.  For example:

BGA>             mug=> create table "MyTest" ( a int4 default 10 );
BGA>             ERROR:  mytest: Table does not exist.
BGA>             mug=> 
BGA> The Solution:
BGA>         I haven't the faintest idea!


I have this error also using CHECK... but the error message goes away
if I create, drop and re-create the table...

prova=> create table "MyTest" ( a int4 check(a>0) );
ERROR:  mytest: Table does not exist.
prova=> create table "MyTest" ( a int4 );
CREATE
prova=> drop table "MyTest";
DROP
prova=> create table "MyTest" ( a int4 check(a>0) );
CREATE

-Jose'-



Thu, 12 Nov 1998 12:44:28 +0100
Sferacarta Software <sferac@bo.nettuno.it>
Re: [HACKERS] A problem with the constraint system.
> BGA> Creating a table with a name containing mixed case that has a
> BGA> constraint, the creation will fail.  For example:
> BGA>   mug=> create table "MyTest" ( a int4 default 10 );
> BGA>   ERROR:  mytest: Table does not exist.

I have a fix for this, though I've only tested with your example. Here
is the patch...

                      - Tom
Thu, 12 Nov 1998 15:17:24 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] A problem with the constraint system.