Thank you John. That perfectly answered by question. Regards Anil
On Sat, Nov 1, 2014 at 2:43 AM, John R Pierce <pie...@hogranch.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 > >
