[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