Changes between Version 7 and Version 8 of TracProject/ToDo

Timestamp:

Oct 1, 2009, 9:05:43 PM (15 years ago)

Author:

Christian Boos

Comment:

adapted SQL for deleting the tobedeleted tickets to PostgreSQL

TracProject/ToDo

@@ -5 +5 @@
  - Purge all the dummy tickets marked for deletion:
    {{{
+#!sql
+-- (for PostgreSQL)
 create view tobedeleted as
-  select id, status, resolution, keywords 
+  select id, summary, status, resolution, keywords 
   from ticket 
   where keywords like '%tobedeleted%' and status='closed' and resolution='invalid'; 
 delete from ticket_change where ticket in (select id from tobedeleted);
-delete from attachment where type='ticket' and id in (select id from tobedeleted);
+delete from attachment where type='ticket' and id in (select CAST(id AS text) from tobedeleted);
 delete from ticket where id in (select id from tobedeleted);
    }}}