Re: ERROR: heap_mark4update: (am)invalid tid in triggers

Kevin Hendrickson <hndrcksn(at)groupinfo(dot)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