]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
PG nulls not distinct support
authorpavelserchenia <pavel.serchenia@splitmetrics.com>
Fri, 26 May 2023 11:16:54 +0000 (07:16 -0400)
committermike bayer <mike_mp@zzzcomputing.com>
Tue, 6 Jun 2023 17:58:32 +0000 (17:58 +0000)
commitf6dc8b872d6f8b1eaa114c7128125bc4edf646d3
treed5d8ab87fef8f1479781886fbe1ec431bd655e11
parent693b8744ee45ebb65bfcbb9156935ffb2a3ee9ad
PG nulls not distinct support

Added support for PostgreSQL 10 ``NULLS NOT DISTINCT`` feature of
unique indexes and unique constraint using the dialect option
postgresql_nulls_not_distinct``.
Updated the reflection logic to also correctly take this option
into account.

Fixes: #8240
Closes: #9834
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/9834
Pull-request-sha: 825a4ff13a1f428470e184944a167c9d4c57e604

Change-Id: I6585fbb05ad32a131cf9ba25a59f7b229bce5b52
doc/build/changelog/unreleased_20/8240.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mssql/base.py
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/dialects/postgresql/pg_catalog.py
lib/sqlalchemy/engine/reflection.py
lib/sqlalchemy/sql/compiler.py
test/dialect/postgresql/test_compiler.py
test/dialect/postgresql/test_reflection.py