[Babase] Maturity requirement violations

Susan Alberts alberts at duke.edu
Mon Feb 6 17:44:30 EST 2006


Thanks Karl,

It makes no difference to us how these data are entered -- all of the 
animals in question should have the dates in question assigned so it 
would be easy to add them to foxpro. We will just go ahead and do 
this unless the other way is better.

Susan

>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


-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan Alberts, Associate Professor 
Department of Biology, Duke University, Box 90338, Durham NC 27708 
phone 919-660-7272  fax 919-660-7293


More information about the Babase mailing list