From: | "Billy G(dot) Allie" <Bill(dot)Allie(at)mug(dot)org> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org (Hackers PostgreSQL) |
Subject: | A problem with the constraint system. |
Date: | 1998-11-12 04:49:10 |
Message-ID: | 199811120449.XAA03902@bgalli.mug.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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(dot)Allie(at)mug(dot)org
| /| | 7436 Hartwell | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie(at)email(dot)msn(dot)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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-11-12 04:56:24 | Re: OK now :-) was Re: [HACKERS] regression tests |
Previous Message | Alvaro C P Barbosa | 1998-11-12 01:09:42 | Questions about PostgreSQL |