Re: Trigger firing order odd?

Sample code should have been:

CREATE TABLE zzz (
f1 integer
);

--
-- TOC entry 632 (OID 3098251)
-- Name: zzz_tg_proc (); Type: FUNCTION; Schema: public; Owner: pgsql
--

CREATE or REPLACE FUNCTION zzz_tg_proc () RETURNS "trigger"
AS 'Begin Raise NOTICE ''In trigger %'',TG_NAME; return NEW;end'
LANGUAGE plpgsql;

CREATE FUNCTION zzz_proc () RETURNS void
AS 'Begin Raise NOTICE ''In proc'';
update zzz set f1 = 2 where f1=1;
Raise NOTICE ''Updating again'';
update zzz set f1 = 1 where f1=2;
Raise NOTICE ''Leaving Proc'';
return;
end;' Language 'plpgsql';

CREATE TRIGGER zzz_upd_bef_tg
BEFORE UPDATE ON zzz
FOR EACH ROW
EXECUTE PROCEDURE zzz_tg_proc ();

CREATE TRIGGER zzz_upd_aft_tg
AFTER UPDATE ON zzz
FOR EACH ROW
EXECUTE PROCEDURE zzz_tg_proc ();

CREATE TRIGGER zzz_add_bef_tg
BEFORE INSERT ON zzz
FOR EACH ROW
EXECUTE PROCEDURE zzz_tg_proc ();

CREATE TRIGGER zzz_add_aft_tg
AFTER INSERT ON zzz
FOR EACH ROW
EXECUTE PROCEDURE zzz_tg_proc ();

insert into zzz values(1);
NOTICE: In trigger zzz_add_bef_tg
NOTICE: In trigger zzz_add_aft_tg

select zzz_proc();
NOTICE: In proc
NOTICE: In trigger zzz_upd_bef_tg
NOTICE: Updating again
NOTICE: In trigger zzz_upd_bef_tg
NOTICE: Leaving Proc
NOTICE: In trigger zzz_upd_aft_tg
NOTICE: In trigger zzz_upd_aft_tg

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/