-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The problem:
Creating a table with a name containing mixed case that has aconstraint, 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-----