]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Reflect schema-qualified PostgreSQL collations for columns and DOMAIN
authorMike Bayer <mike_mp@zzzcomputing.com>
Tue, 21 Jul 2026 20:43:28 +0000 (16:43 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Fri, 24 Jul 2026 19:02:47 +0000 (15:02 -0400)
commitb435816d5463eeb30e869a0d70a385eb2e4f5930
treed8dba937665810d99bb0123835eaece68e10c444
parent8cabfe9532c1429ea8aaba1cd85ef68efa0868f9
Reflect schema-qualified PostgreSQL collations for columns and DOMAIN

The PostgreSQL dialect now reflects the schema of a schema-qualified
column or DOMAIN collation, populating the collation_schema parameter
added to String and postgresql.DOMAIN so that reflected DDL round-trips
exactly. The schema is omitted from the reflected value when the
collation is visible on the current search_path without qualification.

Fixes: #6511
Change-Id: Id9c7016659fb0ce5b83d6be5ad172811cea7dd14
doc/build/changelog/migration_21.rst
doc/build/changelog/unreleased_21/6511.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/dialects/postgresql/pg_catalog.py
test/dialect/postgresql/test_reflection.py
test/dialect/postgresql/test_types.py