[Babase] new data
Karl O. Pinc
kop at meme.com
Mon Oct 16 12:14:03 EDT 2006
On 10/16/2006 10:24:18 AM, Leah Gerber wrote:
> Hi Karl,
>
> I am afraid I can't decipher what these two errors mean. I looked at
> both rows on the Foxpro system but can't figure out what is wrong
> with the rows.
>
> ### Add 5653887 to the error messages' source line number
> psql:<stdin>:495: ERROR: duplicate key violates unique constraint
> "samples_pkey"
> ### Add 11472205 to the error messages' source line number
> psql:<stdin>:88920: ERROR: duplicate key violates unique constraint
> "neighbors_pntid_ncode"
>
They are the same errors you'd just been fixing:
(Give me a call if this is not clear.)
------------<snip>------------
Subject: [Babase] New database loaded, mostly
Date: 10/09/2006 11:26:50 PM
There are three sorts of problems. The first is:
duplicate key violates unique constraint "samples_pkey"
There are 6 of these.
These are where the PSION data has no points and has
both a juvenile and a female point sample by the
same observer of the same individual on the same day.
(Could I not have the latest PSION data somehow?)
The second error is:
duplicate key violates unique constraint "neighbors_pntid_ncode"
There are 2 of these.
This is the error we talked about today, each neighbor is
allowed only 1 of any given ncode for any given point
sample.
------------<snip>------------
> Leah
>
> Karl O. Pinc wrote:
>>
>> On 10/13/2006 04:04:08 PM, Leah Gerber wrote:
>>> Hi Karl,
>>>
>>> New data, psion, and dump files are on papio. Not sure if it is
>>> worth running a new conversion before Tabby makes some changes. I
>>> think I got all of the ones i can correct. Who knows though. Extras
>>> always seem to pop up. Let me know if you do run another conversion
>>> and I will check out the errors.
>>
>> Ok. Ran another conversion, into the babase database
>> without all the validation turned on. There's still
>> two "simple" errors left.
>>
>> Files are:
>>
>> /biology/groups/babase/errors/errors.leahagain
>> /biology/groups/babase/errors/loadscript.leahagain
>>
>>
>> I'll run another conversion with full validation
>> into the babase_test database now, just because I can.
>>
>> 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
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list