Re: ERROR: attempted to delete invisible tuple - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: attempted to delete invisible tuple
Date
Msg-id 4288.1250530885@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: attempted to delete invisible tuple  (Bryan Murphy <bmurphy1976@gmail.com>)
Responses Re: ERROR: attempted to delete invisible tuple
List pgsql-general
Bryan Murphy <bmurphy1976@gmail.com> writes:
> On Mon, Aug 17, 2009 at 12:17 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Hm, what's your current XID counter?  (pg_controldata would give an
>> approximate answer.)  I'm wondering if the xmax's are marked committed
>> but are in the future ...

> Latest checkpoint's NextXID:          0/308829887

Hmm, well, they're in the past *now*, but by less than 20000
transactions.  You said this was a production DB so that might not
represent very much elapsed time.  Does the DELETE still fail?

            regards, tom lane

pgsql-general by date:

Previous
From: Bob Gobeille
Date:
Subject: psql command line editor
Next
From: Nuno Mota
Date:
Subject: Re: plpython return setof and yield