"Dan Eloff" <[EMAIL PROTECTED]> writes:
> It seems the trigger list is calculated once, and does not reflect
> changes made by triggers in that list. Are there good reasons for
> doing that? Should that behavior be changed?
Yes. No. Don't hold your breath on this being considered a bug.
I came across this bug tonight:
-- Function: pre_delete_main()
CREATE FUNCTION pre_delete_main()
RETURNS TRIGGER AS
$BODY$BEGIN
DROP TABLE bug_referring_table;
RETURN OLD;
END;$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
-- Table: bug_referenced_table
CREATE TABLE bug_referenced_table
(
