Re: heap_mark4update: (am)invalid tid - Mailing list pgsql-bugs

From:               Tom Lane <tgl@sss.pgh.pa.us>
> "Robert Creager" <pgsql-bugs@logicalchaos.org> writes:
> > I found reference to this problem at
> > http://archives.postgresql.org/pgsql-general/2003-02/msg00135.php,
> > but there was no apparent resolution.
>
> If (a) obs_v_trigger is a BEFORE trigger, *and* (b) the problem UPDATE
> could try to update a row of obs_v more than once (ie, there are
> multiple rows in obs_i/files that match a row in obs_v), then I think
> this is a known problem.  Otherwise, we need to dig more ...
>
>    regards, tom lane

Yes, and yes.  Any work arounds (ie current sources, smarter SQL),
other than to break this up into multiple updates?

Thanks,
Rob