The completely untested patch below should remedy the occasional exceptions that PyPI is occasionally raising. Can someone provide a sanity check for this patch? (I'm not going to deploy it -- not familiar enough with the setup on the live site.)
--amk Index: flamenco.py =================================================================== --- flamenco.py (revision 452) +++ flamenco.py (working copy) @@ -1,6 +1,7 @@ #!/usr/bin/python import sys, pprint, cgi, urllib, os, time, cStringIO +import psycopg def flatten(d): l = d[1] @@ -114,7 +115,8 @@ # overlapping update, just release the lock self.store.commit() return - self.cursor.execute("delete from browse_tally") + try: + self.cursor.execute("delete from browse_tally") # Using PostgreSQL COPY here, instead of a series of INSERT statements s = cStringIO.StringIO() for _, _, items in self.list_choices()[1]: @@ -123,6 +125,8 @@ s.seek(0) self.cursor.copy_from(s, 'browse_tally') self.cursor.execute("update timestamps set value=now() where name='browse_tally'") + except psycopg.ProgrammingError: + pass self.store.commit() def get_matches(self, addl_fields=[]): _______________________________________________ Catalog-sig mailing list Catalog-sig@python.org http://mail.python.org/mailman/listinfo/catalog-sig