[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