Stephan Szabo <[EMAIL PROTECTED]> writes: > On Sun, 15 Jul 2007, 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?
> I don't think the subtransaction subcommit will do the check. Unless I'm > missing something about the code, a CommitTransaction would but a > CommitSubTransaction won't, which actually makes sense given that we're > mapping savepoints on to it, and I don't think we are allowed to check at > savepoint release time. OK, that's what I get for opining before checking the code ;-). It seems a little weird that a subcommitted subtransaction could still cause a failure later, but that is how we're doing the triggers. Given that, the proposed patch seems appropriate. Will apply. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend