Juliano Amaral Chaves <juliano.amaral@xxxxxxxxxxx> wrote: > By doing insert into a table using a query, it seems that all > records of consultation were included bypassing the AFTER INSERT > triggers and as few as after all the records already included, > the TRIGGER is fired for each record, I wonder if this occurrence > is normal. > > I created an example that demonstrates my doubt, where the 1st > case works properly. The 2nd case is restricted by TRIGGER when I > think, that could not be > [ example showing that an AFTER INSERT trigger sees the modified > table as of the state after the INSERT statement completes, > rather than the state after the insert of the individual row ] I can see where that would be confusing, but things are operating as designed, AFAICS. The trigger fires after the statement, not after each affected row is processed. -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
