Re: Basic question regarding insert

Thank you John.
That perfectly answered by question.

Regards
Anil

On Sat, Nov 1, 2014 at 2:43 AM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 10/31/2014 3:24 AM, Anil Menon wrote:
>
> I have a very basic question on inserts - I tried to get a good
> authoritative answer but could not really find one to my satisfaction in
> the usual places.
>
> TLDR : can (after) insert trigger be run in parallel?
>
>
> the trigger is run in the context of the connection and transaction that
> invoked it. the original INSERT doesn't return til any and all triggers
> are processed. OTHER connections can do concurrent inserts to the same
> tables, as long as you're not using explicit table locks.
>
>
>
> --
> john r pierce 37N 122W
> somewhere on the middle of the left coast
>
>