Re: ERROR: heap_mark4update: (am)invalid tid in triggers - Mailing list pgsql-general

Kevin Hendrickson <hndrcksn@groupinfo.com> writes:
> So what is the fix for situations where your table really needs
> a BEFORE action trigger? Is there a patch for Postgresql 7.3.2 that
> addresses this issue yet?

It is patched in CVS; here is the log entry:

2003-03-27 09:33  tgl

    * src/: backend/commands/trigger.c, backend/executor/execMain.c,
    include/commands/trigger.h (REL7_3_STABLE): GetTupleForTrigger must
    use outer transaction's command counter for time qual checking, not
    GetCurrentCommandId.  Per test case from Steve Wolfe.

We are starting to think about a 7.3.3 release, but in the meantime you
could pull the tip of the REL7_3_STABLE branch from our CVS server and
use that.  Or just get the diffs for the above three files and patch
manually.

            regards, tom lane