[Babase] conversion error - matured dates

Leah Gerber lgerber at duke.edu
Mon Mar 13 09:50:56 EST 2006


Karl,

Do the following errors arise because of a constraint in the database 
that only allows ranked or dispersed dates if there is a matured date? I 
am not following why these are errors.

Leah

psql:<stdin>:201: ERROR:  insert or update on table "rankdates" violates 
foreign key constraint "Sname on MATUREDATES"
DETAIL:  Key (sname)=(ROC) is not present in table "maturedates".

psql:<stdin>:159: ERROR:  insert or update on table "dispersedates" 
violates foreign key constraint "Sname on MATUREDATES"
DETAIL:  Key (sname)=(PES) is not present in table "maturedates".

psql:<stdin>:39: ERROR:  insert or update on table "dispersedates" 
violates foreign key constraint "Sname on MATUREDATES"
DETAIL:  Key (sname)=(HIC) is not present in table "maturedates".

psql:<stdin>:45: ERROR:  insert or update on table "dispersedates" 
violates foreign key constraint "Sname on MATUREDATES"
DETAIL:  Key (sname)=(SEB) is not present in table "maturedates".



More information about the Babase mailing list