[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