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