10

In PostgreSQL what is the default action over a child table referencing with foreign keys a parent table, on the UPDATE / DELETE events?

The possible ones listed are the following:

NO ACTION | RESTRICT | CASCADE | SET NULL | SET DEFAULT

I imagine it could be NO ACTION, but the official documentation does not specify it in the events paragraph of the SELECT statement specs (unfortunately, the deeplink to the paragraph is not referenceable).

yodabar
  • 4,651
  • 2
  • 33
  • 38

1 Answers1

16

It's right there in the description of the REFERENCES clause

Quote from the manual

NO ACTION

.... This is the default action.

Community
  • 1
  • 1
  • 1
    Thanks a lot. I put some effort for the second time, but I couldn't really find occurrences of `NO ACTION` or occurrences of `REFERENCES` in that page, which could clarify me that. – yodabar Apr 05 '18 at 17:42