- fix to postgres sequence quoting when using schemas

2 files changed, 2 insertions, 1 deletions

diff --git a/CHANGES b/CHANGES
index 9b17f1648..acddae34f 100644
--- a/CHANGES
+++ b/CHANGES
@@ -7,6 +7,7 @@ loaded already.  this can be turned off (i.e. the old behavior) by setting
 passive_deletes=True on a relation().
 - MySQL catches exception on "describe" and reports as NoSuchTableError
 - further fixes to sqlite booleans, weren't working as defaults
+- fix to postgres sequence quoting when using schemas
 
 0.3.0
 - General:
diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py
index bcbe5f670..5c78e2f52 100644
--- a/lib/sqlalchemy/databases/postgres.py
+++ b/lib/sqlalchemy/databases/postgres.py
@@ -530,7 +530,7 @@ class PGDefaultRunner(ansisql.ANSIDefaultRunner):
                 # TODO: this has to build into the Sequence object so we can get the quoting 
                 # logic from it
                 if sch is not None:
-                    exc = "select nextval('\"%s.%s_%s_seq\"')" % (sch, column.table.name, column.name)
+                    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)