During looking stuff up for a discussion on -general, I realized that

Bruce Momjian <bruce@momjian.us>

Commit: 535756649f8989b460ca1b32803649cdcc6e5c63
Author: Bruce Momjian <bruce@momjian.us>
Date: 2003-06-11T15:02:25Z
Releases: 7.4.1
During looking stuff up for a discussion on -general, I realized that
I'd placed the check for newly created matching pk rows for on update no
action earlier than it needed to be so that it'd check even when the key
values hadn't changed.  This patch moves it to after checking for NULLs
in the old row and comparing the values since the select's probably more
expensive.

Stephan Szabo

Files

PathChange+/−
src/backend/utils/adt/ri_triggers.c modified +13 −12