[Babase] Problems with ALLMISCS.Atime data

Karl O. Pinc kop at meme.com
Fri Jul 13 17:39:20 EDT 2007


Hi,

In the process of allowing both 'O' and 'U' type
ALLMISCS.Txt data I'm now adding additional
validation to ALLMISCS.   One thing I'm doing
is testing ALLMISCS.Atime and limiting it like
I'm limiting POINT_DATA.Ptime -- to between
05:00 and 19:00, inclusive.

The following ALLMISCS rows have bad Ptime values,
values > 19:00.  These need to be fixed.  Now
that we're not converting any longer, and these
rows are already in the database, this email is
the only record of the problem with this data
so please take care not to lose track of this
task.

(This query "limited" to avoid revealing data
on a public mailing list.)

babase=> select almid, sid from allmiscs where atime > '19:00';
  almid |  sid
-------+-------
     50 |  2937
    374 |  5321
    408 |  5596
    409 |  5596
    416 |  5645
    417 |  5662
    464 |  6135
   2041 | 36783
(8 rows)


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