]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
make qtoken for PostgreSQL _fk_regex_pattern less restrictive
authorGord Thompson <gord@gordthompson.com>
Mon, 19 Jan 2026 12:34:28 +0000 (05:34 -0700)
committerMike Bayer <mike_mp@zzzcomputing.com>
Wed, 21 Jan 2026 01:17:29 +0000 (20:17 -0500)
commit0c81b8fa1b8510ae70f9a372c6f7c054d56808b8
treeb5fd350a45478c7dfbdbe2821440196abe32354b
parenta5390affc9c68fd09b0b7bdaa13e2bc4e8e87894
make qtoken for PostgreSQL _fk_regex_pattern less restrictive

Improved the foreign key reflection regular expression pattern used by the
PostgreSQL dialect to be more permissive in matching identifier characters,
allowing it to correctly handle unicode characters in table and column
names. This change improves compatibility with PostgreSQL variants such as
CockroachDB that may use different quoting patterns in combination with
unicode characters in their identifiers.  Pull request courtesy Gord
Thompson.

Change-Id: Iaee340879400e01df2f776417e8b1018f1801cfe
(cherry picked from commit d0d9f1b71115471b0a6918075383c2bddf2212b1)
doc/build/changelog/unreleased_20/pg_fk_reflect.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/postgresql/base.py
test/dialect/postgresql/test_reflection.py