Re: [HACKERS] 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'-