Mercurial > p > roundup > code
comparison roundup/backends/back_postgresql.py @ 8298:cfa7d43a3658
backout bbc99def147a. All the other backends were programmed to accomodate the skip one nature of postgres sequences
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Mon, 20 Jan 2025 16:32:39 -0500 |
| parents | bbc99def147a |
| children | 82a26ea1afdf |
comparison
equal
deleted
inserted
replaced
| 8297:03513f5066f3 | 8298:cfa7d43a3658 |
|---|---|
| 546 sql = "select nextval('_%s_ids') from dual" % classname | 546 sql = "select nextval('_%s_ids') from dual" % classname |
| 547 self.sql(sql) | 547 self.sql(sql) |
| 548 return str(self.cursor.fetchone()[0]) | 548 return str(self.cursor.fetchone()[0]) |
| 549 | 549 |
| 550 def setid(self, classname, setid): | 550 def setid(self, classname, setid): |
| 551 sql = "select setval('_%s_ids', %s, false) from dual" % (classname, | 551 sql = "select setval('_%s_ids', %s) from dual" % (classname, |
| 552 int(setid)) | 552 int(setid)) |
| 553 self.sql(sql) | 553 self.sql(sql) |
| 554 | 554 |
| 555 def clear(self): | 555 def clear(self): |
| 556 rdbms_common.Database.clear(self) | 556 rdbms_common.Database.clear(self) |