Re: attempted to lock invisible tuple - PG 8.4.1

Alvaro Herrera wrote:
> Stuart Bishop wrote:

> > The test case (invisible.sh) and required dump (foodump.sql - 60k) are
> > at http://www.stuartbishop.net/invisible/
>
> Got it, thanks, looking.

Here's a slightly smaller test case; basically I removed the tsearch2
cruft and extra columns in the table. One thing of note is that if the
COPY commands is reduced to occupy less than one page in the target
table, the problem does not occur.

To reproduce, restore the attached file and run
BEGIN;
SET transaction_isolation TO SERIALIZABLE;
UPDATE Bug2 SET name='foobar' WHERE id=1;
ABORT;

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.