[Babase] New database loaded, mostly

Karl O. Pinc kop at meme.com
Tue Oct 10 00:26:50 EDT 2006


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



More information about the Babase mailing list