[Babase] Conversion error - time constraint in point_data
Leah Gerber
lgerber at duke.edu
Wed Mar 8 16:08:54 EST 2006
Karl,
The following errors show up in the conversion error files. I copied the
error and the corresponding rows from FPSAMPS. Do you want to keep the
constraint that says the point sample must be taken before 19:00? There
is only one day in the database where this actually happens. Also, I
noticed that 7 errors show up but only 6 rows violate the constraint as
it is written. Perhaps you have the constraint coded as < 19:00 instead
of <=19:00. I will deal with the error if this is actually a true error.
psql:<stdin>:108789: ERROR: new row for relation "point_data" violates
check constraint "Time <= 19:00"
psql:<stdin>:108792: ERROR: new row for relation "point_data" violates
check constraint "Time <= 19:00"
psql:<stdin>:108795: ERROR: new row for relation "point_data" violates
check constraint "Time <= 19:00"
psql:<stdin>:108798: ERROR: new row for relation "point_data" violates
check constraint "Time <= 19:00"
psql:<stdin>:108801: ERROR: new row for relation "point_data" violates
check constraint "Time <= 19:00"
psql:<stdin>:108804: ERROR: new row for relation "point_data" violates
check constraint "Time <= 19:00"
psql:<stdin>:108807: ERROR: new row for relation "point_data" violates
check constraint "Time <= 19:00"
fpid sid activity posture kidcontact kidsuckle time foodcode
datetime
135593 21880 W 1 A N 18:59
12/10/2003 18:59
135594 21880 F 2 A N 19:00 FTP 12/10/2003 19:00
135595 21880 F 1 A N 19:01 FTG 12/10/2003 19:01
135596 21880 R 2 A N 19:02
12/10/2003 19:02
135597 21880 F 1 A N 19:03 FTP 12/10/2003 19:03
135598 21880 W 1 A N 19:04
12/10/2003 19:04
135599 21880 F 1 A N 19:05 FTP 12/10/2003 19:05
135600 21880 F 1 A N 19:08 FTP 12/10/2003 19:08
Thanks, Leah
More information about the Babase
mailing list