From e8d8fa14b63a994ac1e0953bbe494a7c6ade9572 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 1 Mar 2006 07:22:53 +0000 Subject: added schema support for postgres column defaults, fix for [ticket:88] --- lib/sqlalchemy/databases/postgres.py | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'lib/sqlalchemy') diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py index 7bb329ccb..67e3d5cf5 100644 --- a/lib/sqlalchemy/databases/postgres.py +++ b/lib/sqlalchemy/databases/postgres.py @@ -338,7 +338,12 @@ class PGDefaultRunner(ansisql.ANSIDefaultRunner): c = self.proxy("select %s" % column.default.arg) return c.fetchone()[0] elif isinstance(column.type, types.Integer) and (column.default is None or (isinstance(column.default, schema.Sequence) and column.default.optional)): - c = self.proxy("select nextval('%s_%s_seq')" % (column.table.name, column.name)) + sch = column.table.schema + if sch is not None: + exc = "select nextval('%s.%s_%s_seq')" % (sch, column.table.name, column.name) + else: + exc = "select nextval('%s_%s_seq')" % (column.table.name, column.name) + c = self.proxy(exc) return c.fetchone()[0] else: return ansisql.ANSIDefaultRunner.get_column_default(self, column) -- cgit v1.2.1