Horton

A problem with the constraint system.

Billy G. Allie <bill.allie@mug.org>

View thread
From: "Billy G. Allie" <Bill.Allie@mug.org>
To: pgsql-hackers@postgreSQL.org (Hackers PostgreSQL)
Date: 1998-11-12T04:49:10Z
Lists: pgsql-hackers 
-----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-----