Index: trunk/ippToPsps/config/tables.DO.vot
===================================================================
--- trunk/ippToPsps/config/tables.DO.vot	(revision 39254)
+++ trunk/ippToPsps/config/tables.DO.vot	(revision 39255)
@@ -6,15 +6,21 @@
       <DESCRIPTION>Contains the positional information for difference detection objects in a number of coordinate systems.  The objects associate difference detections within a one arcsecond radius.  The number of detections in each filter from is listed, along with maximum coverage fractions.  References: Szalay, A. S., Gray, J., Fekete, G., et al. 2007, arXiv:cs/0701164.</DESCRIPTION>
       <PARAM arraysize="1" datatype="char" ucd="meta.bib.author" name="Author" value="PSPS"></PARAM>
-      <FIELD name="diffObjName" arraysize="100" datatype="char" unit="dimensionless" default="NA">
+      <FIELD name="diffObjName" arraysize="32" datatype="char" unit="dimensionless" default="NA">
         <DESCRIPTION>IAU name for this object.</DESCRIPTION>
       </FIELD>
-      <FIELD name="diffObjAltName1" arraysize="100" datatype="char" unit="dimensionless" default="NA">
+      <FIELD name="diffObjPSOName" arraysize="32" datatype="char" unit="dimensionless" default="NA">
 	<DESCRIPTION>Alternate Pan-STARRS name for this object.</DESCRIPTION>
       </FIELD>
-      <FIELD name="diffObjAltName2" arraysize="100" datatype="char" unit="dimensionless" default="">
+      <FIELD name="diffObjAltName1" arraysize="32" datatype="char" unit="dimensionless" default="">
 	<DESCRIPTION>Altername name for this object.</DESCRIPTION>
       </FIELD>
-      <FIELD name="diffObjAltName3" arraysize="100" datatype="char" unit="dimensionless" default="">
+      <FIELD name="diffObjAltName2" arraysize="32" datatype="char" unit="dimensionless" default="">
 	<DESCRIPTION>Altername name for this object.</DESCRIPTION>
+      </FIELD>
+      <FIELD name="diffObjAltName3" arraysize="32" datatype="char" unit="dimensionless" default="">
+	<DESCRIPTION>Altername name for this object.</DESCRIPTION>
+      </FIELD>
+      <FIELD name="diffObjPopularName" arraysize="140" datatype="char" unit="dimensionless" default="">
+	<DESCRIPTION>Well known name for this object.</DESCRIPTION>
       </FIELD>
       <FIELD name="diffObjID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
Index: trunk/ippToPsps/config/tables.OB.vot
===================================================================
--- trunk/ippToPsps/config/tables.OB.vot	(revision 39254)
+++ trunk/ippToPsps/config/tables.OB.vot	(revision 39255)
@@ -11,12 +11,18 @@
         <DESCRIPTION>IAU name for this object.</DESCRIPTION>
       </FIELD>
-      <FIELD name="objAltName1" arraysize="100" datatype="char" unit="dimensionless" default="NA">
+      <FIELD name="objPSOName" arraysize="32" datatype="char" unit="dimensionless" default="NA">
 	<DESCRIPTION>Alternate Pan-STARRS name for this object.</DESCRIPTION>
       </FIELD>
-      <FIELD name="objAltName2" arraysize="100" datatype="char" unit="dimensionless" default="">
+      <FIELD name="objAltName1" arraysize="32" datatype="char" unit="dimensionless" default="NA">
+	<DESCRIPTION>Alternate name for this object.</DESCRIPTION>
+      </FIELD>
+      <FIELD name="objAltName2" arraysize="32" datatype="char" unit="dimensionless" default="">
 	<DESCRIPTION>Altername name for this object.</DESCRIPTION>
       </FIELD>
-      <FIELD name="objAltName3" arraysize="100" datatype="char" unit="dimensionless" default="">
+      <FIELD name="objAltName3" arraysize="32" datatype="char" unit="dimensionless" default="">
 	<DESCRIPTION>Altername name for this object.</DESCRIPTION>
+      </FIELD>
+      <FIELD name="objPopularName" arraysize="140" datatype="char" unit="dimensionless" default="">
+	<DESCRIPTION>Well known name for this object.</DESCRIPTION>
       </FIELD>
       <FIELD name="objID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
Index: trunk/ippToPsps/jython/diffobjectbatch.py
===================================================================
--- trunk/ippToPsps/jython/diffobjectbatch.py	(revision 39254)
+++ trunk/ippToPsps/jython/diffobjectbatch.py	(revision 39255)
@@ -210,64 +210,7 @@
     def updateDiffObjName(self):
     ##this is a 2 part update:
-
-        self.logger.infoPair("updating diffObjName", "using means")
-    ## use mean ra and dec (dec >= 0)
-        sql = "update DiffDetObject set diffObjName =  concat('PSO J', \
-        lpad(floor(ra/15.),2,'0'), \
-        lpad(format((ra/15. - (floor(ra/15.)))*60.,0), 2, '0'), \
-        lpad(format(((ra/15. - (floor(ra/15.)))*60. - floor((ra/15.-(floor(ra/15.)))*60.))*60.,2),5,'0'), \
-        '+', \
-        lpad(floor(abs(dec_)),2,'0'), \
-        lpad(format((abs(dec_)-(floor(abs(dec_))))*60.,0), 2, '0'), \
-        lpad(format(((abs(dec_)-(floor(abs(dec_))))*60.-floor((abs(dec_)-(floor(abs(dec_))))*60.))*60.,2),5,'0') \
-        ) where ra > -999 and dec_ > -999 and dec_ >= 0"
-
-        try:
-            self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair("failed sql", sql)
-            raise
- 
-    ## use mean ra and dec (dec < 0)
-
-        sql = "update DiffDetObject set diffObjName =  concat('PSO J', \
-        lpad(floor(ra/15.),2,'0'), \
-        lpad(format((ra/15. - (floor(ra/15.)))*60.,0), 2, '0'), \
-        lpad(format(((ra/15. - (floor(ra/15.)))*60. - floor((ra/15.-(floor(ra/15.)))*60.))*60.,2),5,'0'), \
-        '-', \
-        lpad(floor(abs(dec_)),2,'0'), \
-        lpad(format((abs(dec_)-(floor(abs(dec_))))*60.,0), 2, '0'), \
-        lpad(format(((abs(dec_)-(floor(abs(dec_))))*60.-floor((abs(dec_)-(floor(abs(dec_))))*60.))*60.,2),5,'0') \
-        ) where ra > -999 and dec_ > -999 and dec_ < 0"
-
-        try:
-            self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair("failed sql", sql)
-            raise
-
-        ## Update altName with decimal form
-        self.logger.infoPair("updating diffObjAltName1", "using means")
-        
-        sql = "update DiffDetObject SET diffObjAltName1 = concat('PSO J', \
-        format(ra,4),'+',format(dec_,4)) where ra > -999 AND dec_ > -999 AND dec_ >= 0 "
-
-        try:
-            self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair("failed sql", sql)
-            raise
-            return False
-
-        sql = "update DiffDetObject SET diffObjAltName1 = concat('PSO J', \
-        format(ra,4),format(dec_,4)) where ra > -999 AND dec_ > -999 AND dec_ < 0"
-
-        try:
-            self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair("failed sql", sql)
-            raise
-            return False
-
+        self.logger.info("Names are now populated with the populateDiffObjectTable call")
+
+        return True
 
     '''
@@ -322,4 +265,6 @@
         sqlLine.group("ra",                "RA_MEAN")
         sqlLine.group("dec_",              "DEC_MEAN")
+        sqlLine.group("diffObjName",       "IAU_NAME")
+        sqlLine.group("diffObjPSOName",    "PSO_NAME")
         sqlLine.group("nDetections",       "'0'")
         sql = sqlLine.makeRaw(") SELECT ", " FROM " + cptTableName)
Index: trunk/ippToPsps/jython/objectbatch.py
===================================================================
--- trunk/ippToPsps/jython/objectbatch.py	(revision 39254)
+++ trunk/ippToPsps/jython/objectbatch.py	(revision 39255)
@@ -247,127 +247,7 @@
     '''
     def updateObjName(self):
-    ##this is a 4 part update:
-        self.logger.infoPair("updating objName", "using stacks")
-
-    ## if we have a stackra and dec, use stackra and dec , dec >=0
-
-        sql = "update ObjectThin set objName =  concat('PSO J', \
-        lpad(floor(raStack/15.),2,'0'), \
-        lpad(format((raStack/15. - (floor(raStack/15.)))*60.,0), 2, '0'), \
-        lpad(format(((raStack/15. - (floor(raStack/15.)))*60. - floor((raStack/15.-(floor(raStack/15.)))*60.))*60.,2),5,'0'), \
-        '+', \
-        lpad(floor(abs(decStack)),2,'0'), \
-        lpad(format((abs(decStack)-(floor(abs(decStack))))*60.,0), 2, '0'), \
-        lpad(format(((abs(decStack)-(floor(abs(decStack))))*60.-floor((abs(decStack)-(floor(abs(decStack))))*60.))*60.,2),5,'0') \
-        ) where raStack > -999 and decStack > -999 and decStack >= 0"
-        try:
-            self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair("failed sql", sql)
-            raise
-            return False
-
-    ## if we have a stackra and dec, use stackra and dec, dec < 0
-
-        sql = "update ObjectThin set objName =  concat('PSO J', \
-        lpad(floor(raStack/15.),2,'0'), \
-        lpad(format((raStack/15. - (floor(raStack/15.)))*60.,0), 2, '0'), \
-        lpad(format(((raStack/15. - (floor(raStack/15.)))*60. - floor((raStack/15.-(floor(raStack/15.)))*60.))*60.,2),5,'0'), \
-        '-', \
-        lpad(floor(abs(decStack)),2,'0'), \
-        lpad(format((abs(decStack)-(floor(abs(decStack))))*60.,0), 2, '0'), \
-        lpad(format(((abs(decStack)-(floor(abs(decStack))))*60.-floor((abs(decStack)-(floor(abs(decStack))))*60.))*60.,2),5,'0') \
-        ) where raStack > -999 and decStack > -999 and decStack < 0"
-        try:
-            self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair("failed sql", sql)
-            raise
-            return False
-
-        self.logger.infoPair("updating objName", "using means")
-
-
-    ## use mean ra and dec (dec >= 0)
-        sql = "update ObjectThin set objName =  concat('PSO J', \
-        lpad(floor(raMean/15.),2,'0'), \
-        lpad(format((raMean/15. - (floor(raMean/15.)))*60.,0), 2, '0'), \
-        lpad(format(((raMean/15. - (floor(raMean/15.)))*60. - floor((raMean/15.-(floor(raMean/15.)))*60.))*60.,2),5,'0'), \
-        '+', \
-        lpad(floor(abs(decMean)),2,'0'), \
-        lpad(format((abs(decMean)-(floor(abs(decMean))))*60.,0), 2, '0'), \
-        lpad(format(((abs(decMean)-(floor(abs(decMean))))*60.-floor((abs(decMean)-(floor(abs(decMean))))*60.))*60.,2),5,'0') \
-        ) where raMean > -999 and decMean > -999 and decMean >= 0 AND objName IS NULL"
-
-        try:
-            self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair("failed sql", sql)
-            raise
-            return False
- 
-    ## use mean ra and dec (dec < 0)
-
-        sql = "update ObjectThin set objName =  concat('PSO J', \
-        lpad(floor(raMean/15.),2,'0'), \
-        lpad(format((raMean/15. - (floor(raMean/15.)))*60.,0), 2, '0'), \
-        lpad(format(((raMean/15. - (floor(raMean/15.)))*60. - floor((raMean/15.-(floor(raMean/15.)))*60.))*60.,2),5,'0'), \
-        '-', \
-        lpad(floor(abs(decMean)),2,'0'), \
-        lpad(format((abs(decMean)-(floor(abs(decMean))))*60.,0), 2, '0'), \
-        lpad(format(((abs(decMean)-(floor(abs(decMean))))*60.-floor((abs(decMean)-(floor(abs(decMean))))*60.))*60.,2),5,'0') \
-        ) where raMean > -999 and decMean > -999 and decMean < 0 AND objName IS NULL"
-        try:
-            self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair("failed sql", sql)
-            raise
-            return False
-
-
-        # update altname
-        self.logger.infoPair("updating objAltName1", "using stacks")
-        
-        sql = "update ObjectThin SET objAltName1 = concat('PSO J', \
-        format(raStack,4),'+',format(decStack,4)) where raStack > -999 AND decStack > -999 AND decStack >= 0 "
-        try:
-            self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair("failed sql", sql)
-            raise
-            return False
-
-        sql = "update ObjectThin SET objAltName1 = concat('PSO J', \
-        format(raStack,4),format(decStack,4)) where raStack > -999 AND decStack > -999 AND decStack < 0 "
-        try:
-            self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair("failed sql", sql)
-            raise
-            return False
-
-        self.logger.infoPair("updating objAltName1", "using means")
-        
-        sql = "update ObjectThin SET objAltName1 = concat('PSO J', \
-        format(raMean,4),'+',format(decMean,4)) where raMean > -999 AND decMean > -999 AND decMean >= 0 AND objAltName1 IS NULL"
-        try:
-            self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair("failed sql", sql)
-            raise
-            return False
-
-        sql = "update ObjectThin SET objAltName1 = concat('PSO J', \
-        format(raMean,4),format(decMean,4)) where raMean > -999 AND decMean > -999 AND decMean < 0 AND objAltName1 IS NULL"
-        try:
-            self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair("failed sql", sql)
-            raise
-            return False
-
-        
-
-
+        self.logger.info("Names are now populated with the populateObjectThinTable call")
+
+        return True
     '''
     Populates the Object table
@@ -428,4 +308,6 @@
         sqlLine.group("raMean",          "RA_MEAN")
         sqlLine.group("decMean",         "DEC_MEAN")
+        sqlLine.group("objName",         "IAU_NAME")
+        sqlLine.group("objPSOName",      "PSO_NAME")
         sqlLine.group("epochMean",       "EPOCH_MEAN")
         sqlLine.group("raMeanErr",       "RA_ERR")