====== Qc1 Tweaks ====== UPDATE checks SET active='* * * * 3001'; UPDATE checks SET active='* * * * *' WHERE checkname='precipcollected_flag'; kvalobs=# select * from checks where checkname like '%recip%flag'; stationid|qcx|medium_qcx|language|checkname|checksignature|active|fromtime 0|QC1-7-110|QC1-7|1|precipcollected_flag|obs;RR_24&&&302;;0,-46080|refobs;KLSTART,KLOBS;;|* * * * *|1500-01-01 00:00:00 (1 rad) Try this first then see if need to update the -46080 (is this already 32 days or 12 hours?) Strange thinsg now happening: kvalobs=# select * from data where paramid=110 and obstime>'2010-02-01' and obstime<'2010-02-17' and typeid=302 and stationid=91400 order by obstime; stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed -----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------- 91400 | 2010-02-01 06:00:00 | -32767 | 110 | 2010-02-03 20:29:19 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 | 91400 | 2010-02-02 06:00:00 | -32767 | 110 | 2010-02-03 14:14:12 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 | 91400 | 2010-02-03 06:00:00 | -32767 | 110 | 2010-02-04 00:33:05 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 | 91400 | 2010-02-04 06:00:00 | -1 | 110 | 2010-02-04 13:10:56 | 302 | 0 | 0 | -1 | 0000000000000000 | 9999900000000000 | 91400 | 2010-02-08 06:00:00 | 2 | 110 | 2010-02-09 08:18:34 | 302 | 0 | 0 | 2 | 0000000000000000 | 9999900000000000 | 91400 | 2010-02-09 06:00:00 | -1 | 110 | 2010-02-09 08:19:35 | 302 | 0 | 0 | -1 | 0000000000000000 | 9999900000000000 | 91400 | 2010-02-15 06:00:00 | 19.9 | 110 | 2010-02-15 06:52:48 | 302 | 0 | 0 | 19.9 | 0000000000000000 | 9999900000000000 | 91400 | 2010-02-16 06:00:00 | 1.2 | 110 | 2010-02-16 07:25:35 | 302 | 0 | 0 | 1.2 | 0000000000000000 | 9999900000000000 | (8 rows) i.e. missing rows are not being generated ??? What controls this? Turn back on range_checks: UPDATE checks SET active='* * * * *' WHERE checkname='RANGE_CHECK'; 161 changes made ... Mmmmmmm looks like this has been happening for a while ... what generates missing rows?