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 ] }
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 |