From 2d8dca043b6f880695baa9fb20ed2fdf222c15d9 Mon Sep 17 00:00:00 2001 From: Federico Caselli Date: Wed, 17 Mar 2021 21:28:44 +0100 Subject: [PATCH] Rename column name that used a reserved word Rename column name used by a reflection query that used a reserved word in some postgresql compatible databases. Fixes: #6082 Change-Id: Ie81983316b72601a2e34543fa5ee95371e68aaf5 --- doc/build/changelog/unreleased_14/6082.rst | 6 ++++++ lib/sqlalchemy/dialects/postgresql/base.py | 2 +- 2 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 doc/build/changelog/unreleased_14/6082.rst diff --git a/doc/build/changelog/unreleased_14/6082.rst b/doc/build/changelog/unreleased_14/6082.rst new file mode 100644 index 0000000000..ea1cd65f03 --- /dev/null +++ b/doc/build/changelog/unreleased_14/6082.rst @@ -0,0 +1,6 @@ +.. change:: + :tags: postgresql, usecase + :tickets: 6982 + + Rename the column name used by a reflection query that used + a reserved word in some postgresql compatible databases. \ No newline at end of file diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index 68a145e016..d52cc2ae6f 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -3591,7 +3591,7 @@ class PGDialect(default.DefaultDialect): ) as identity_options\ """ else: - identity = "NULL as identity" + identity = "NULL as identity_options" SQL_COLS = """ SELECT a.attname, -- 2.47.2