X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate45.py;h=fe84c9be87627b1d800de02ad6b9e05c4e1b9b84;hb=5fab292532bd8d1a4b041c137393b33031841f95;hp=0a12d5bc7c1fd44c3ffc06312d1aeae96098ddd1;hpb=3a82a780e7f5821ecfcc005aa97c463014b5dfed;p=dak.git diff --git a/dak/dakdb/update45.py b/dak/dakdb/update45.py old mode 100755 new mode 100644 index 0a12d5bc..fe84c9be --- a/dak/dakdb/update45.py +++ b/dak/dakdb/update45.py @@ -42,12 +42,12 @@ CREATE TABLE extra_src_references ( bin_id INT4 NOT NULL REFERENCES binaries(id) ON DELETE CASCADE, src_id INT4 NOT NULL REFERENCES source(id) ON DELETE RESTRICT, - UNIQUE (bin_id, src_id) + PRIMARY KEY (bin_id, src_id) )""") c.execute("UPDATE config SET value = '45' WHERE name = 'db_revision'") self.db.commit() - except psycopg2.ProgrammingError, msg: + except psycopg2.ProgrammingError as msg: self.db.rollback() - raise DBUpdateError, 'Unable to apply update 45, rollback issued. Error message : %s' % (str(msg)) + raise DBUpdateError('Unable to apply update 45, rollback issued. Error message : %s' % (str(msg)))