Horton

Re: Trigger violates foreign key constraint

shihao zhong <zhong950419@gmail.com>

View thread View on postgr.es
From: shihao zhong <zhong950419@gmail.com>
To: pgsql-hackers@lists.postgresql.org
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Date: 2023-10-30T21:08:55Z
Lists: pgsql-hackers 
The following review has been posted through the commitfest application:
make installcheck-world:  not tested
Implements feature:       not tested
Spec compliant:           not tested
Documentation:            tested, passed

It seems like people have been talking about this problem since 2010 (https://stackoverflow.com/questions/3961825/foreign-keys-in-postgresql-can-be-violated-by-trigger), and we finally got our act together and put it in the official document today, only 13 years later.

The new status of this patch is: Ready for Committer

Commits

  1. Doc: document that triggers can break referential integrity.