[Babase] UPLOAD pregs error
kfenn
kfenn at princeton.edu
Thu Jan 3 15:05:53 EST 2008
Hi again Karl,
FYI, the Upload program won't let me use anything but the birthdates for
statdates...no super fake dates allowed.
But that's not my current problem.
I just tried to upload two pregs to the pregs table because they were
missing and I can't have an infant enter the biograph table unless there
is a record of a pregnancy.
So, I tried to upload the pregs and got this error message, which I
could understand if were trying to upload a LYE pid at all, but I'm not
(its ABB and ACA). Why is this coming up?
ERROR: LYE2: 3: Parity out of sequence: Mismatch with preceeding
pregnancy CONTEXT: SQL statement "UPDATE pregs SET parity = parity + 1 +
(CASE WHEN parity - (parity % 100) < $1 - ( $2 % 100) THEN 100 ELSE 0
END) FROM cycpoints AS this_cycpoints , cycles AS this_cycles , cycles
AS that_cycles , cycpoints AS that_cycpoints WHERE this_cycpoints.cpid =
$3 AND this_cycles.cid = this_cycpoints.cid AND that_cycles.sname =
this_cycles.sname AND that_cycpoints.cid = that_cycles.cid AND
that_cycpoints.cpid != this_cycpoints.cpid AND pregs.conceive =
that_cycpoints.cpid AND pregs.parity % 100 = $4 % 100" PL/pgSQL function
"pregs_before_func" line 130 at SQL statement
Tabby
--
Tabby Fenn
Research Assistant
Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ 08544
609 258-6898 (Ph)
609 258-2712 (Fx)
More information about the Babase
mailing list