[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