Index: trunk/ippToPsps/jython/dvo.py
===================================================================
--- trunk/ippToPsps/jython/dvo.py	(revision 33259)
+++ trunk/ippToPsps/jython/dvo.py	(revision 33272)
@@ -403,8 +403,13 @@
            self.scratchDb.createIndex(cptTableName, "OBJ_ID")
 
+           self.logger.infoPair("Adding","PSPS objIDs")
+           # first try to add a column for PSPS_OBJ_ID. catch failure and continue
+           try:
+               sql = "ALTER TABLE " + cpmTableName + " ADD COLUMN (PSPS_OBJ_ID BIGINT)"
+               self.scratchDb.execute(sql)
+           except:
+               self.logger.infoPair("Already added PSPS_OBJ_ID column to", cpmTableName)
+               
            # shove PSPS objIDs from cpt table into measurement table
-           self.logger.infoPair("Adding","PSPS objIDs")
-           sql = "ALTER TABLE "+cpmTableName+" ADD COLUMN (PSPS_OBJ_ID BIGINT)"
-           self.scratchDb.execute(sql)
            sql = "UPDATE " + cpmTableName + " AS a, " + cptTableName + " AS b \
                   SET a.PSPS_OBJ_ID = b.EXT_ID \