Re: ERROR: heap_mark4update: (am)invalid tid, after the 14th update in 7.3.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christoph_Becker(at)t-online(dot)de (Christoph_Becker)
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ERROR: heap_mark4update: (am)invalid tid, after the 14th update in 7.3.2
Date: 2003-04-09 04:00:59
Message-ID: 4126.1049860859@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Christoph_Becker(at)t-online(dot)de (Christoph_Becker) writes:
> But the following simplification will produce the error:

> UPDATE p_behbl SET fallnr = p_kvk.lfdnr FROM p_kvk WHERE
> p_behbl.fallnr is null and p_behbl.patnr = p_kvk.patnr;

If there are multiple p_kvk rows matching some p_behbl row, then this
is a known problem. See the archives from a week or two back.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2003-04-09 13:19:57 Bug #939: Function parameter of type int2 fail when called.
Previous Message Tatsuo Ishii 2003-04-09 02:31:05 Re: Conversion on the fly from KOI8-R to WIN1251 is invalid