[Babase] New database loaded, mostly

Leah Gerber lgerber at duke.edu
Tue Oct 10 10:09:10 EDT 2006


Karl,

Is there a loadscript file to go with these errors? They are quite 
cryptic as is.

Thanks,

Leah

Karl O. Pinc wrote:
> Hi,
>
> The babase database is now loaded with the same data that's
> in foxpro, mostly.  There are a few errors.  They are
> in:
>
> login.biology.duke.edu:/biology/groups/babase/errors/errors.leah2
>
> (Leah,)
>
> 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.
>
> The third error type is:
>  new row for relation "neighbors" violates check constraint "Either an 
> Sname or a Unksname but not both is required"
>
> There is 1 of these.
>
> There is also a knock-on error from one of the above problems.
>
> Aside from these problems what's in the babase db is what's
> in foxpro.
>
> 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


More information about the Babase mailing list