On Oct 29, 2005, at 9:48 AM, Bruno Wolff III wrote:
On Sat, Oct 29, 2005 at 13:10:31 +0200,
Martin Lesser <[EMAIL PROTECTED]> wrote:
Which effects have UPDATEs on REFERENCEd TABLEs when only columns
referenced table are updated which are not part of the FOREIGN KEY
In 8.1 there is a check to see if the foreign key value has changed
not a trigger isn't queued. In the currently released versions any
will fire triggers.
The check in comment for trigger.c didn't say if this optimization
to both referencing and referenced keys or just one of those.
If you need to know more you can look at the code at:
It seems like this warrants an item somewhere in the release notes,
and I'm not currently seeing it (or a related item) anywhere. Perhaps
E.1.3.1 (Performance Improvements)? For some of the more extreme
UPDATE scenarios I've seen, this could be a big win.
Thomas F. O'Connell
Co-Founder, Information Architect
Open Source Solutions. Optimized Web Development.
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly