Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: heap_mark4update: (am)invalid tid, after the 14th update in 7.3.2 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: ERROR: heap_mark4update: (am)invalid tid, after the 14th update in 7.3.2
Date
Msg-id 4126.1049860859@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: heap_mark4update: (am)invalid tid, after the 14th update in 7.3.2  (Christoph_Becker@t-online.de (Christoph_Becker))
List pgsql-bugs
Tree view 
Christoph_Becker@t-online.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

pgsql-bugs by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Conversion on the fly from KOI8-R to WIN1251 is invalid
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #939: Function parameter of type int2 fail when called.