I am running a slackware 7 linux box (kernel 2.2.14 g++2.91.66) and i 've installed the ver 7 beta 5. So i had the following problem I suppose when you make a constraint statement for reference key theere should be a check for the fields names , example: create table tbl1 (p1 int2 primary key,p2 int4); and: create table tbl2(p1 int2 primary key, p2 int2, constraint lala foreign key (p2) references tbl1(po1)); (the o in po1 was misstyped) there was no error message( i didn't noticed it too) when i 've tryed the : insert into tbl1 values (1,1); i got the the error that the there was no field 'po1' for the constraint procedure to check. maybe that's because it's a beta version ........ if this was reported earlier excuse me but i am new to the list Spyros Vasileiadis Salonika Greece
