From 28229a35e0231e770679ce48436f7e31723ac159 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 14 Feb 2014 14:39:41 -0500 Subject: - Added server version detection to the newly added dialect startup query for "show standard_conforming_strings"; as this variable was added as of PG 8.2, we skip the query for PG versions older than that as well as for backends like Redshift. #2946 --- lib/sqlalchemy/dialects/postgresql/base.py | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'lib/sqlalchemy/dialects/postgresql/base.py') diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index 1b5927dbd..4cd462a72 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -1567,7 +1567,8 @@ class PGDialect(default.DefaultDialect): # http://www.postgresql.org/docs/9.3/static/release-9-2.html#AEN116689 self.supports_smallserial = self.server_version_info >= (9, 2) - self._backslash_escapes = connection.scalar( + self._backslash_escapes = self.server_version_info < (8, 2) or \ + connection.scalar( "show standard_conforming_strings" ) == 'off' -- cgit v1.2.1