[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