[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