diff roundup/backends/back_postgresql.py @ 3310:3518d1ffd940

merge from maint-0-7
author Richard Jones <richard@users.sourceforge.net>
date Mon, 02 May 2005 05:48:59 +0000
parents 57b60bda9473
children addbe69ff58b
line wrap: on
line diff
--- a/roundup/backends/back_postgresql.py	Mon May 02 01:05:15 2005 +0000
+++ b/roundup/backends/back_postgresql.py	Mon May 02 05:48:59 2005 +0000
@@ -1,4 +1,4 @@
-#$Id: back_postgresql.py,v 1.29 2005-02-14 02:48:11 richard Exp $
+#$Id: back_postgresql.py,v 1.30 2005-05-02 05:48:59 richard Exp $
 #
 # Copyright (c) 2003 Martynas Sklyzmantas, Andrey Lebedev <andrey@micro.lt>
 #
@@ -212,6 +212,14 @@
         sql = "select setval('_%s_ids', %s) from dual"%(classname, int(setid))
         self.sql(sql)
 
+    def clear(self):
+        rdbms_common.Database.clear(self)
+
+        # reset the sequences
+        for cn in self.classes.keys():
+            self.cursor.execute('DROP SEQUENCE _%s_ids'%cn)
+            self.cursor.execute('CREATE SEQUENCE _%s_ids'%cn)
+
 
 class Class(rdbms_common.Class):
     pass

Roundup Issue Tracker: http://roundup-tracker.org/