[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