Deferred RI trigger for non-key UPDATEs and subxacts

From: "Affan Salman" <affan(at)enterprisedb(dot)com>
To: <pgsql-patches(at)postgresql(dot)org>
Subject: Deferred RI trigger for non-key UPDATEs and subxacts
Date: 2007-07-13 23:12:55
Message-ID: 469806F7.40502@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


With some time to spare, I thought I'd submit a quick-fix patch to the
issue I reported here:

http://archives.postgresql.org/pgsql-hackers/2007-07/msg00339.php

This should preclude optimizing away a deferred RI trigger if the
UPDATEd row (in the FK table) was inserted by "current" transaction
(i.e. defined by TransactionIdIsCurrentTransactionId()) and not
necessarily "by our own transaction" as the code currently says.
________________________________________________________________________

backend/commands/trigger.c | 17 !!!!!!!!!!!!!!!!!
test/regress/expected/foreign_key.out | 15 +++++++++++++++
test/regress/sql/foreign_key.sql | 19 +++++++++++++++++++
3 files changed, 34 insertions(+), 17 modifications(!)
________________________________________________________________________

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

Attachment Content-Type Size
pgsqlHEAD_FK-UpdateDeferredRI-SubxactFix.patch text/x-patch 4.2 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2007-07-14 09:13:28 GSSAPI support on solaris
Previous Message Simon Riggs 2007-07-13 20:26:57 Re: Transaction Guarantee, updated version