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