diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2009-01-02 21:24:17 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2009-01-02 21:24:17 +0000 |
| commit | 5bc1f17cb53248e7cea609693a3b2a9bb702545b (patch) | |
| tree | e31a0341ecacd3115612fcebfc904f1549535465 /lib/sqlalchemy/databases/postgres.py | |
| parent | 2f2d84fbb14f1282677de8fc1186da8f41081214 (diff) | |
| download | sqlalchemy-5bc1f17cb53248e7cea609693a3b2a9bb702545b.tar.gz | |
- mysql, postgres: "%" signs in text() constructs are automatically escaped to "%%".
Because of the backwards incompatible nature of this change,
a warning is emitted if '%%' is detected in the string. [ticket:1267]
Diffstat (limited to 'lib/sqlalchemy/databases/postgres.py')
| -rw-r--r-- | lib/sqlalchemy/databases/postgres.py | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py index 273f5859e..6fd0662de 100644 --- a/lib/sqlalchemy/databases/postgres.py +++ b/lib/sqlalchemy/databases/postgres.py @@ -719,6 +719,11 @@ class PGCompiler(compiler.DefaultCompiler): else: return "nextval('%s')" % self.preparer.format_sequence(seq) + def post_process_text(self, text): + if '%%' in text: + util.warn("The SQLAlchemy psycopg2 dialect now automatically escapes '%' in text() expressions to '%%'.") + return text.replace('%', '%%') + def limit_clause(self, select): text = "" if select._limit is not None: |