A problem with the constraint system.

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-----

Responses

Browse pgsql-hackers by date

  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