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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
