diff options
| author | Federico Caselli <cfederico87@gmail.com> | 2021-03-25 21:08:21 +0100 |
|---|---|---|
| committer | Federico Caselli <cfederico87@gmail.com> | 2021-03-25 21:08:21 +0100 |
| commit | 3fe8d618e3614edc8f9e4241e7521a984f2f21c6 (patch) | |
| tree | 2f40cd4f8bb18ab51ec935f9563389928e92bdc8 /lib/sqlalchemy/dialects/postgresql/base.py | |
| parent | acd0122c2cb9ad0fe0cf92b306ea50dd51ec88b8 (diff) | |
| download | sqlalchemy-3fe8d618e3614edc8f9e4241e7521a984f2f21c6.tar.gz | |
Fixed reflection of identity columns in tables
with mixed case names in PostgreSQL.
Fixes: #6129
Change-Id: I50480cec03fcb44a668c9b0f9c72950803b771d9
Diffstat (limited to 'lib/sqlalchemy/dialects/postgresql/base.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/postgresql/base.py | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index d52cc2ae6..6e6f5513d 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -3582,12 +3582,11 @@ class PGDialect(default.DefaultDialect): 'cycle', s.seqcycle) FROM pg_catalog.pg_sequence s JOIN pg_catalog.pg_class c on s.seqrelid = c."oid" - JOIN pg_catalog.pg_namespace n on n.oid = c.relnamespace WHERE c.relkind = 'S' AND a.attidentity != '' - AND n.nspname || '.' || c.relname = - pg_catalog.pg_get_serial_sequence( - a.attrelid::regclass::text, a.attname) + AND s.seqrelid = pg_catalog.pg_get_serial_sequence( + a.attrelid::regclass::text, a.attname + )::regclass::oid ) as identity_options\ """ else: |