From: Mike O'Connor <stew@vireo.org>
Date: Sat, 9 Jan 2010 19:30:47 +0000 (-0500)
Subject: forgot to save update29
X-Git-Url: https://git.decadent.org.uk/gitweb/?p=dak.git;a=commitdiff_plain;h=f90df828922ffa76826827203ccdc7f451db61f0

forgot to save update29

Signed-off-by: Mike O'Connor <stew@vireo.org>
---

diff --git a/dak/dakdb/update29.py b/dak/dakdb/update29.py
index 5df1ad81..891fcf2f 100644
--- a/dak/dakdb/update29.py
+++ b/dak/dakdb/update29.py
@@ -38,15 +38,10 @@ def do_update(self):
 
     try:
         c = self.db.cursor()
-        c.execute("""DROP AGGREGATE comma_separated_list(                   BASETYPE = text,
-                   SFUNC = comma_concat,
-                   STYPE = text,
-                   INITCOND = ''
-);""" )
-        c.execute("""DROP FUNCTION comma_concat(text, text);""" );
+        c.execute("""DROP FUNCTION comma_concat(text, text) CASCADE;""" );
         c.execute("""DROP TABLE pending_content_associations;""")
         c.execute("""DROP TABLE content_associations;""")
-        c.execute("""DROP TABLE content_file_names;""")
+        c.execute("""DROP TABLE content_filecd ._names;""")
         c.execute("""DROP TABLE content_file_paths;""")
 
         c.execute("UPDATE config SET value = '29' WHERE name = 'db_revision'")