X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate28.py;h=0d1f22089b52c133d575a14dda5bff5d3711c4dd;hb=f291297ba4eab8ab5f130002acb2675c997f291c;hp=23db522baba44f2319184a5cd43baf2d72068a00;hpb=af14c3715925b2ea8f877a0ef4e473b26567a433;p=dak.git

diff --git a/dak/dakdb/update28.py b/dak/dakdb/update28.py
index 23db522b..0d1f2208 100755
--- a/dak/dakdb/update28.py
+++ b/dak/dakdb/update28.py
@@ -149,11 +149,11 @@ def do_update(self):
             arch_list = arches(c, suite_id)
 
             for (arch_id,arch_str) in arch_list:
-                c.execute( "CREATE INDEX ind_deb_contents_%s_%s ON deb_contents (arch,suite) WHERE (arch=2 OR arch=%s) AND suite=%s"%(arch_str,suite,arch_id,suite_id) )
+                c.execute( "CREATE INDEX ind_deb_contents_%s_%s ON deb_contents (arch,suite) WHERE (arch=2 OR arch=%s) AND suite='%s'"%(arch_str,suite,arch_id,suite_id) )
 
             for section, sname in [("debian-installer","main"),
                                   ("non-free/debian-installer", "nonfree")]:
-                c.execute( "CREATE INDEX ind_udeb_contents_%s_%s ON udeb_contents (section,suite) WHERE section=%s AND suite=%s"%(sname,suite,section,suite_id) )
+                c.execute( "CREATE INDEX ind_udeb_contents_%s_%s ON udeb_contents (section,suite) WHERE section='%s' AND suite='%s'"%(sname,suite,section,suite_id) )
 
 
         c.execute( """CREATE OR REPLACE FUNCTION update_contents_for_bin_a() RETURNS trigger AS  $$