Trigger question - Mailing list pgsql-general

From Daniel Schuchardt
Subject Trigger question
Date
Msg-id cgkcgr$2k25$1@news.hub.org
Whole thread Raw
Responses Re: Trigger question  (Daniel Schuchardt <daniel_schuchardt@web.de>)
List pgsql-general
Hi list,

i'm a bit confused. I have a table with a trigger after insert. It is
possible that this trigger will do inserts in the same table, but is the
after insert trigger fired again in this case? (I would need this)

e.g.

USER INSERT

BEFORE TRIGGER
AFTER TRIGGER

->DECIDES TO INSERT X ROWS IN THE SAME TABLE

->BEFORE TRIGGER (this one is fired for each row the after trigger inserts)

->AFTER TRIGGER AGAIN???? FOR EACH ROW THE AFTER TRIGGER INSERTED

thnx a lot.
Daniel

pgsql-general by date:

Previous
From: Michal Hlavac
Date:
Subject: Re: Stored procedure failure
Next
From: Richard Huxton
Date:
Subject: Re: ltree bug handling nulls (was Stored procedure failure)