Обсуждение: [MASSMAIL]What is referential_action?
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?
[ 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 ] }
[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]
[snip]
FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]
[ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE referential_action ] [ ON UPDATE referential_action ] }
[ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE referential_action ] [ ON UPDATE referential_action ] }
> On Apr 8, 2024, at 06:37, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>
> Four times, the word "referential_action" is used on this page, but it's never mentioned what the possible
referentialactions are.
They're defined in CREATE TABLE:
https://www.postgresql.org/docs/14/sql-createtable.html
On Monday, April 8, 2024, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
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?
Much of the details regarding the things you can alter onto a table are defined in create table reference for the same thing.
David J.
On Mon, Apr 8, 2024 at 9:41 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Monday, April 8, 2024, Ron Johnson <ronljohnsonjr@gmail.com> wrote: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?Much of the details regarding the things you can alter onto a table are defined in create table reference for the same thing.
Thanks, Chris and David.