Re: Deferred RI trigger for non-key UPDATEs and subxacts - Mailing list pgsql-patches

From Affan Salman
Subject Re: Deferred RI trigger for non-key UPDATEs and subxacts
Date
Msg-id 469B3878.8090000@enterprisedb.com
Whole thread Raw
In response to Re: Deferred RI trigger for non-key UPDATEs and subxacts  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tom Lane wrote:
>  I don't think this is right.  If the original tuple was inserted by a
>  subtransaction of our transaction, it will have been checked at
>  subtransaction subcommit, no?

No, it will be checked at main transaction commit; the immediate_only
flag is FALSE for afterTriggerMarkEvents() only through the invocation
of AfterTriggerFireDeferred(), which comes from CommitTransaction() or
PrepareTransaction().

--
Affan Salman
EnterpriseDB Corporation                      http://www.enterprisedb.com



pgsql-patches by date:

Previous
From: NikhilS
Date:
Subject: Re: CREATE TABLE LIKE INCLUDING INDEXES support
Next
From: Neil Conway
Date:
Subject: Re: CREATE TABLE LIKE INCLUDING INDEXES support