Marc Spitzer <marc(at)oscar(dot)eng(dot)cv(dot)net> writes:
> Would one of these conditions include deleting a row where there is
> a field that is used as a foreign-key in another table?
[ thinks ... ] Yes, I think so. The cases I'm familiar with involve
inserts and updates, but probably a delete on the referenced table would
fire triggers as well. With enough pending triggers, 7.0 and 7.1 will
get slow. See discussions of 'triggered data change violation' error
in the archives.
regards, tom lane