Cache NO ACTION foreign keys separately from RESTRICT foreign keys
authorPeter Eisentraut
Sun, 9 Feb 2025 12:43:56 +0000 (13:43 +0100)
committerPeter Eisentraut
Sun, 9 Feb 2025 12:43:56 +0000 (13:43 +0100)
commit9926f854d07784d72aada16c8038b558fbc45d13
tree2e7d34e49253006b039e61b281aa077a795c8e1b
parenta9258629edabd461f998ec7d06cdf554e8a6a6ec
Cache NO ACTION foreign keys separately from RESTRICT foreign keys

Now that we generate different SQL for temporal NO ACTION vs RESTRICT
foreign keys, we should cache their query plans with different keys.
Since the key also includes the constraint oid, this shouldn't be
necessary, but we have been seeing build farm failures that suggest we
might be sometimes using a cached NO ACTION plan to implement a RESTRICT
constraint.

Author: Paul A. Jungwirth 
Discussion: https://www.postgresql.org/message-id/flat/CA+renyUApHgSZF9-nd-a0+OPGharLQLO=mDHcY4_qQ0+noCUVg@mail.gmail.com
src/backend/utils/adt/ri_triggers.c