[Babase] Maturity requirement violations

Leah Gerber lgerber at duke.edu
Mon Feb 6 17:32:33 EST 2006


Karl,

I have an excel table of matured dates that are not yet in Babase. If 
you want I can enter them manually. This may solve the problems.

Leah

Karl O. Pinc wrote:
> 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
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase



More information about the Babase mailing list