diff options
| -rw-r--r-- | doc/build/changelog/unreleased_20/9442.rst | 7 | ||||
| -rw-r--r-- | lib/sqlalchemy/dialects/postgresql/base.py | 13 |
2 files changed, 16 insertions, 4 deletions
diff --git a/doc/build/changelog/unreleased_20/9442.rst b/doc/build/changelog/unreleased_20/9442.rst new file mode 100644 index 000000000..2b172195c --- /dev/null +++ b/doc/build/changelog/unreleased_20/9442.rst @@ -0,0 +1,7 @@ +.. change:: + :tags: usecase, postgresql + :tickets: 9442 + + Modifications to the base PostgreSQL dialect to allow for better integration with the + sqlalchemy-redshift third party dialect for SQLAlchemy 2.0. Pull request courtesy + matthewgdv. diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index 3ba103802..3c1fc0073 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -3030,10 +3030,7 @@ class PGDialect(default.DefaultDialect): # https://www.postgresql.org/docs/9.3/static/release-9-2.html#AEN116689 self.supports_smallserial = self.server_version_info >= (9, 2) - std_string = connection.exec_driver_sql( - "show standard_conforming_strings" - ).scalar() - self._backslash_escapes = std_string == "off" + self._set_backslash_escapes(connection) self._supports_drop_index_concurrently = self.server_version_info >= ( 9, @@ -4699,3 +4696,11 @@ class PGDialect(default.DefaultDialect): domains.append(domain_rec) return domains + + def _set_backslash_escapes(self, connection): + # this method is provided as an override hook for descendant + # dialects (e.g. Redshift), so removing it may break them + std_string = connection.exec_driver_sql( + "show standard_conforming_strings" + ).scalar() + self._backslash_escapes = std_string == "off" |