[Babase] Conversion error - time constraint in point_data

Karl O. Pinc kop at meme.com
Wed Mar 8 18:07:50 EST 2006


I got the time from Susan, so whatever she and Jeanne say.
(If it's good data, let's keep it....)
Let me know re the <=.

On 03/08/2006 03:08:54 PM, Leah Gerber wrote:
> 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
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
> 

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