[Babase] Conversion error - time constraint in point_data

Susan Alberts alberts at duke.edu
Thu Mar 9 07:41:02 EST 2006


I am sure that this was an error in which the Psion clock was set 
incorrectly or something. They never collect data after 1900, for the 
simple reason that it is dark and the animals are in the trees and 
they can't see them. < or <= makes no difference. Any samples 
collected after 1900 or before 0700 should be deleted. I have emailed 
the team to confirm.

Susan

>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
>
>_______________________________________________
>Babase mailing list
>Babase at www.eco.princeton.edu
>http://www.eco.princeton.edu/mailman/listinfo/babase


-- 
--------------------------------------------------------------------------------------------------------------------------------------
Susan Alberts, Department of Biology, Duke University, Box 90338, 
Durham NC 27708
919-660-7272 (phone), 919-660-7293 (FAX)


More information about the Babase mailing list