X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate33.py;h=9624ba627b93daf42d0ec3b99274f1dfe3635e97;hb=707183e8538ece020a741fee60e56c73ae3a61c6;hp=5c0b3f41202872274b1356d36413bbbac998bcb6;hpb=076d0a9a0f88c8e86fc206b491f73ea6e8c71fa0;p=dak.git

diff --git a/dak/dakdb/update33.py b/dak/dakdb/update33.py
index 5c0b3f41..9624ba62 100644
--- a/dak/dakdb/update33.py
+++ b/dak/dakdb/update33.py
@@ -43,7 +43,7 @@ def do_update(self):
         c.execute('CREATE TABLE changelogs_text (id serial PRIMARY KEY NOT NULL, changelog text)')
         c.execute("GRANT SELECT ON changelogs_text TO public")
         c.execute("GRANT ALL ON changelogs_text TO ftpmaster")
-        c.execute('CREATE VIEW changelogs AS SELECT cl.id, source, version, architecture, changelog \
+        c.execute('CREATE VIEW changelogs AS SELECT cl.id, source, CAST(version AS debversion), architecture, changelog \
                    FROM changes c JOIN changelogs_text cl ON cl.id = c.changelog_id')
         c.execute("GRANT SELECT ON changelogs TO public")
         c.execute("GRANT ALL ON changelogs TO ftpmaster")