]> granicus.if.org Git - postgresql/commit
Apply RI trigger skipping tests also for DELETE
authorPeter Eisentraut <peter_e@gmx.net>
Thu, 19 Jul 2018 06:37:32 +0000 (08:37 +0200)
committerPeter Eisentraut <peter_e@gmx.net>
Sat, 10 Nov 2018 15:14:51 +0000 (16:14 +0100)
commit69ee2ff9308bbfe0e0a89667555e901fec5e154b
tree4e6825615d84c5a1a3e46eec38c6ea098e15a203
parent34479d9a36a280afe1387146871d4c1528cf2cbf
Apply RI trigger skipping tests also for DELETE

The tests added in cfa0f4255bb0f5550d37a01c4d8fe2966d20040c to skip
firing an RI trigger if any old key value is NULL can also be applied
for DELETE.  This should give a performance gain in those cases, and it
also saves a lot of duplicate code in the actual RI triggers.  (That
code was already dead code for the UPDATE cases.)

Reviewed-by: Daniel Gustafsson <daniel@yesql.se>
src/backend/commands/trigger.c
src/backend/utils/adt/ri_triggers.c