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

From Tom Lane
Subject Re: heap_mark4update: (am)invalid tid
Date
Msg-id 16266.1050124766@sss.pgh.pa.us
Whole thread Raw
In response to heap_mark4update: (am)invalid tid  ("Robert Creager" <pgsql-bugs@logicalchaos.org>)
Responses Re: heap_mark4update: (am)invalid tid  ("Robert Creager" <pgsql-bugs@logicalchaos.org>)
List pgsql-bugs
"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

pgsql-bugs by date:

Previous
From: Sergey Tikhonenko
Date:
Subject: Re: Bug #938: Wrong UPDATE if exist INNER JOIN and alias
Next
From: Stephan Szabo
Date:
Subject: Re: Bug #938: Wrong UPDATE if exist INNER JOIN and alias