Changeset 36097 for trunk/Ohana

Timestamp:

Sep 4, 2013, 10:57:03 AM (13 years ago)

Author:

eugene

Message:

convert INSERT to INSERT IGNORE to ignore the handful of duplicates

File:

• trunk/Ohana/src/dvopsps/src/insert_detections_dvopsps_catalog.c (modified) (1 diff)

trunk/Ohana/src/dvopsps/src/insert_detections_dvopsps_catalog.c

@@ -174 +174 @@
 
   // PrintIOBuffer (buffer, "INSERT INTO dvoDetectionFull (imageID, ippDetectID, detectID, ippObjID, objID, photcode, flags, zp, zpErr, airMass, expTime, ra, dec_, raErr, decErr) VALUES \n");
-  PrintIOBuffer (buffer, "INSERT INTO dvoDetectionFull (imageID, ippDetectID, detectID, ippObjID, objID, flags, zp, zpErr, airMass, expTime, ra, dec_, raErr, decErr) VALUES \n");
+  PrintIOBuffer (buffer, "INSERT IGNORE INTO dvoDetectionFull (imageID, ippDetectID, detectID, ippObjID, objID, flags, zp, zpErr, airMass, expTime, ra, dec_, raErr, decErr) VALUES \n");
 
   return TRUE;