Index: trunk/ippTools/share/camtool_find_pendingexp.sql
===================================================================
--- trunk/ippTools/share/camtool_find_pendingexp.sql	(revision 19538)
+++ trunk/ippTools/share/camtool_find_pendingexp.sql	(revision 19558)
@@ -25,6 +25,6 @@
     WHERE
         chipRun.state = 'full'
-        AND camRun.state = 'new'
+        AND ((camRun.state = 'new' AND camProcessedExp.cam_id IS NULL)
+            OR camRun.state = 'update')
         AND camMask.label IS NULL
-        AND camProcessedExp.cam_id IS NULL
     ) as Foo
Index: trunk/ippTools/share/difftool_todiffskyfile.sql
===================================================================
--- trunk/ippTools/share/difftool_todiffskyfile.sql	(revision 19538)
+++ trunk/ippTools/share/difftool_todiffskyfile.sql	(revision 19558)
@@ -5,4 +5,5 @@
     diffRun.tess_id,
     diffRun.label,
+    diffRun.state,
     rawExp.camera
 FROM diffRun
@@ -26,8 +27,11 @@
     ON diffInputSkyfile.diff_id = diffSkyfile.diff_id
 WHERE
-  diffRun.state = 'new'
-  AND warpRun.state = 'full'
-  AND fakeRun.state = 'full'
-  AND camRun.state = 'full'
-  AND chipRun.state = 'full'
-  AND diffSkyfile.diff_id IS NULL
+  ((diffRun.state = 'new'
+      AND warpRun.state = 'full'
+      AND fakeRun.state = 'full'
+      AND camRun.state = 'full'
+      AND chipRun.state = 'full'
+      AND diffSkyfile.diff_id IS NULL)
+  OR (diffRun.state = 'update'
+      AND diffSkyfile.data_state = 'cleaned')
+  )
Index: trunk/ippTools/share/faketool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/faketool_pendingimfile.sql	(revision 19538)
+++ trunk/ippTools/share/faketool_pendingimfile.sql	(revision 19558)
@@ -41,6 +41,11 @@
         ON fakeRun.label = fakeMask.label
     WHERE
-        fakeProcessedImfile.fake_id IS NULL
-        AND fakeProcessedImfile.class_id IS NULL
+        ((fakeRun.state = 'new'
+            AND fakeProcessedImfile.fake_id IS NULL
+            AND fakeProcessedImfile.class_id IS NULL
+        ) 
+        OR (fakeRun.state = 'update'
+            AND fakeProcessedImfile.data_state = 'cleaned')
+        )
         AND fakeMask.label IS NULL
     ) as fakePendingImfile
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 19538)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 19558)
@@ -399,4 +399,5 @@
     hostname VARCHAR(64),
     path_base VARCHAR(255),
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
Index: trunk/ippTools/share/stacktool_tosum.sql
===================================================================
--- trunk/ippTools/share/stacktool_tosum.sql	(revision 19538)
+++ trunk/ippTools/share/stacktool_tosum.sql	(revision 19558)
@@ -5,4 +5,5 @@
     stackRun.workdir,
     stackRun.label,
+    stackRun.state,
     rawExp.camera
 FROM stackRun
@@ -26,4 +27,7 @@
     USING(stack_id)
 WHERE
-    stackRun.state = 'new'
-    AND stackSumSkyfile.stack_id IS NULL
+    ((stackRun.state = 'new'
+        AND stackSumSkyfile.stack_id IS NULL)
+    OR
+    (stackRun.state = 'update' 
+        AND stackSumSkyfile.data_state = 'cleaned'))
Index: trunk/ippTools/share/warptool_towarped.sql
===================================================================
--- trunk/ippTools/share/warptool_towarped.sql	(revision 19538)
+++ trunk/ippTools/share/warptool_towarped.sql	(revision 19558)
@@ -29,11 +29,14 @@
     ON warpRun.label = warpMask.label
 WHERE
-    warpRun.state = 'new'
+    ((warpRun.state = 'new'
+        AND warpSkyfile.warp_id IS NULL
+        AND warpSkyfile.skycell_id IS NULL
+        AND warpSkyfile.tess_id IS NULL)
+    OR (warpRun.state = 'update'
+        AND warpSkyfile.data_state = 'cleaned')
+    )
     AND fakeRun.state = 'full'
     AND camRun.state = 'full'
     AND chipRun.state = 'full'
-    AND warpSkyfile.warp_id IS NULL
-    AND warpSkyfile.skycell_id IS NULL
-    AND warpSkyfile.tess_id IS NULL
+    AND warpMask.label IS NULL
     AND warpSkyCellMap.fault = 0
-    AND warpMask.label IS NULL