Re: heap_mark4update: (am)invalid tid

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> "Robert Creager" <pgsql-bugs(at)logicalchaos(dot)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