Postgres Pro
Downloads
Home   >   mailing lists

[MASSMAIL]What is referential_action? - Mailing list pgsql-general

From Ron Johnson
Subject [MASSMAIL]What is referential_action?
Date
Msg-id CANzqJaDTmLjhOoZQv8KSid1jBK6C_qS2gMeE6OoTTntQV9MWEw@mail.gmail.com
Whole thread Raw
Responses Re: What is referential_action?  (Christophe Pettus <xof@thebuild.com>)
Re: What is referential_action?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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 ] }

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

pgsql-general by date:

Previous
From: Marko Sutic
Date:
Subject: [MASSMAIL] LwLocks contention (MultiXactOffsetControlLock/multixact_offset) when running logical replication initial snapshot
Next
From: Christophe Pettus
Date:
Subject: Re: What is referential_action?