for some reason psql likes ; more than :

Signed-off-by: Joerg Jaspert <joerg@debian.org>

diff --git a/dak/dakdb/update42.py b/dak/dakdb/update42.py
index 8e8f7c5644a5d49b7ef510d8915193837ac6ce89..48bc9d61af4ccc8b9c6f83b4cbe9334dc668ee7e 100755 (executable)
--- a/dak/dakdb/update42.py
+++ b/dak/dakdb/update42.py
@@ -39,7 +39,7 @@ def do_update(self):
         c = self.db.cursor()
 
         c.execute("ALTER TABLE suite ADD COLUMN butautomaticupgrades BOOLEAN NOT NULL DEFAULT FALSE;")
-        c.execute("ALTER TABLE suite ADD CONSTRAINT bau_needs_na_set CHECK (not butautomaticupgrades or notautomatic):")
+        c.execute("ALTER TABLE suite ADD CONSTRAINT bau_needs_na_set CHECK (not butautomaticupgrades or notautomatic);")
 
         c.execute("UPDATE config SET value = '42' WHERE name = 'db_revision'")
         self.db.commit()