Re: Insert with query

Juliano Amaral Chaves <juliano(dot)amaral(at)hotmail(dot)com> 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