]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Support column list for foreign key ON DELETE SET actions on PostgreSQL
authorDenis Laxalde <denis@laxalde.org>
Thu, 13 Mar 2025 12:43:53 +0000 (08:43 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Mon, 17 Mar 2025 18:02:54 +0000 (14:02 -0400)
commitf6296c19f557111c5b34a8403d97a76b701280b3
tree13bf0385f77b4fdc3c97ef3a3a7c16db03e6f29c
parent4167b3f2b419618d0b56402cd6ad3dabc3b5a18e
Support column list for foreign key ON DELETE SET actions on PostgreSQL

Added support for specifying a list of columns for ``SET NULL`` and ``SET
DEFAULT`` actions of ``ON DELETE`` clause of foreign key definition on
PostgreSQL.  Pull request courtesy Denis Laxalde.

Fixes: #11595
Closes: #12421
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/12421
Pull-request-sha: d0394db7066ba8a8eaf3d3972d779f3e170e9406

Change-Id: I036a559ae4a8efafe9ba64d776a840bd785a7397
(cherry picked from commit 39bb17442ce6ac9a3dde5e2b72376b77ffce5e28)
doc/build/changelog/unreleased_20/11595.rst [new file with mode: 0644]
doc/build/core/constraints.rst
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/sql/compiler.py
lib/sqlalchemy/sql/schema.py
test/dialect/postgresql/test_compiler.py
test/dialect/postgresql/test_reflection.py
test/sql/test_compiler.py