- added "schema" argument to Sequence; use this with Postgres /Oracle when the sequence is

  located in an alternate schema.  Implements part of [ticket:584], should fix [ticket:761].

1 files changed, 5 insertions, 2 deletions

diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py
index 2b4786cb2..4fca6b2ec 100644
--- a/lib/sqlalchemy/sql/compiler.py
+++ b/lib/sqlalchemy/sql/compiler.py
@@ -1000,8 +1000,11 @@ class IdentifierPreparer(object):
     def should_quote(self, object):
         return object.quote or self._requires_quotes(object.name)
 
-    def format_sequence(self, sequence):
-        return self.__generic_obj_format(sequence, sequence.name)
+    def format_sequence(self, sequence, use_schema=True):
+        name = self.__generic_obj_format(sequence, sequence.name)
+        if use_schema and sequence.schema is not None:
+            name = self.__generic_obj_format(sequence, sequence.schema) + "." + name
+        return name
 
     def format_label(self, label, name=None):
         return self.__generic_obj_format(label, name or label.name)