What is referential_action?

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: What is referential_action?
Date: 2024-04-08 13:37:07
Message-ID: CANzqJaDTmLjhOoZQv8KSid1jBK6C_qS2gMeE6OoTTntQV9MWEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Four times, the word "referential_action" is used on this page, but it's
never mentioned what the possible referential actions are.

Am I missing something?

https://www.postgresql.org/docs/14/sql-altertable.html

[ CONSTRAINT constraint_name ]
[snip]
PRIMARY KEY index_parameters |
REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL |
MATCH SIMPLE ]
[ ON DELETE referential_action ] [ ON UPDATE referential_action ] }

[ CONSTRAINT constraint_name ]
[snip]
FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [,
... ] ) ]
[ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE
referential_action ] [ ON UPDATE referential_action ] }

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2024-04-08 13:39:42 Re: What is referential_action?
Previous Message Marko Sutic 2024-04-08 12:48:33 LwLocks contention (MultiXactOffsetControlLock/multixact_offset) when running logical replication initial snapshot