From f4a129c38a6244a64c20b823ebbdebc3e72f69ed Mon Sep 17 00:00:00 2001 From: Denis Laxalde Date: Thu, 13 Mar 2025 08:31:12 +0100 Subject: [PATCH] Document support of column list of ON DELETE SET actions for PostgreSQL --- doc/build/core/constraints.rst | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/doc/build/core/constraints.rst b/doc/build/core/constraints.rst index c63ad858e2..1d8d4990df 100644 --- a/doc/build/core/constraints.rst +++ b/doc/build/core/constraints.rst @@ -311,6 +311,11 @@ arguments. The value is any string which will be output after the appropriate Note that these clauses require ``InnoDB`` tables when used with MySQL. They may also not be supported on other databases. +On PostgreSQL, the ``SET NULL`` and ``SET DEFAULT`` actions of ``ON DELETE`` +clause also accept a list of columns to cascade on; e.g., ``ON DELETE SET NULL +(note_id)``. Otherwise, all columns in the foreign key constraint are normally +considered. + .. seealso:: For background on integration of ``ON DELETE CASCADE`` with -- 2.47.3