[Babase] Maturity requirement violations
Karl O. Pinc
kop at meme.com
Mon Feb 6 17:27:57 EST 2006
Hi,
I got the following four errors below because the individuals
do not have maturity dates. There are two choices:
1) Give them maturity dates in foxpro (and perhaps change the
ON/BY status manually after conversion.)
2) Re-enter the data manually in the new system, supplying the
maturity dates and the consortdate/etc. (We have this option
because I don't think that there are dependencies on RANKDATES,
CONSORTDATES, or MATUREDATES.)
------------<SNIP>-----------
psql:<stdin>:150: ERROR: insert or update on table "rankdates"
violates foreign
key constraint "Sname on MATUREDATES"
DETAIL: Key (sname)=(RUT) is not present in table "maturedates".
psql:<stdin>:201: ERROR: insert or update on table "rankdates"
violates foreign
key constraint "Sname on MATUREDATES"
DETAIL: Key (sname)=(EXO) is not present in table "maturedates".
psql:<stdin>:129: ERROR: insert or update on table "consortdates"
violates fore
ign key constraint "Sname on MATUREDATES"
DETAIL: Key (sname)=(RUT) is not present in table "maturedates".
psql:<stdin>:162: ERROR: insert or update on table "dispersedates"
violates for
eign key constraint "Sname on MATUREDATES"
DETAIL: Key (sname)=(PES) is not present in table "maturedates".
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list