Reviewers: ,
Please review this at http://codereview.tryton.org/141002/
Affected files:
M trytond/backend/postgresql/table.py
Index: trytond/backend/postgresql/table.py
===================================================================
--- a/trytond/backend/postgresql/table.py
+++ b/trytond/backend/postgresql/table.py
@@ -32,7 +32,7 @@
if not self.history:
self.cursor.execute('ALTER TABLE "%s" ' \
'ADD COLUMN id INTEGER ' \
- 'DEFAULT nextval(\'%s\') NOT NULL' % \
+ 'DEFAULT nextval(\'"%s"\') NOT NULL' % \
(self.table_name, self.sequence_name))
self.cursor.execute('ALTER TABLE "%s" ' \
'ADD PRIMARY KEY(id)' % self.table_name)
@@ -43,17 +43,17 @@
if self.history and not '__id' in self._columns:
self.cursor.execute('ALTER TABLE "%s" ' \
'ADD COLUMN __id INTEGER ' \
- 'DEFAULT nextval(\'%s\') NOT NULL' % \
+ 'DEFAULT nextval(\'"%s"\') NOT NULL' % \
(self.table_name, self.sequence_name))
self.cursor.execute('ALTER TABLE "%s" ' \
'ADD PRIMARY KEY(__id)' % self.table_name)
if self.history:
self.cursor.execute('ALTER TABLE "%s" ' \
- 'ALTER __id SET DEFAULT nextval(\'%s\')' %
(self.table_name,
+ 'ALTER __id SET DEFAULT nextval(\'"%s"\')' %
(self.table_name,
self.sequence_name))
else:
self.cursor.execute('ALTER TABLE "%s" ' \
- 'ALTER id SET DEFAULT nextval(\'%s\')' %
(self.table_name,
+ 'ALTER id SET DEFAULT nextval(\'"%s"\')' %
(self.table_name,
self.sequence_name))
self._update_definitions()
--
[email protected] mailing list
