Re: Basic question regarding insert

John R Pierce <pierce@xxxxxxxxxxxx> · Fri, 31 Oct 2014 11:43:58 -0700



    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