Re: Failure while inserting parent tuple to B-tree is not fun - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Failure while inserting parent tuple to B-tree is not fun
Date
Msg-id 5377.1382474285@sss.pgh.pa.us
Whole thread Raw
In response to Re: Failure while inserting parent tuple to B-tree is not fun  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Failure while inserting parent tuple to B-tree is not fun  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> On 2013-10-22 15:24:40 -0400, Tom Lane wrote:
>> No, that's hardly a good idea.  As Heikki says, that would amount to
>> converting an entirely foreseeable situation into a PANIC.

> But IIUC this can currently lead to an index giving wrong answers, not
> "just" fail at further inserts?

No.  It's exactly the same situation as when the insert is still in
progress, ie searches have to move right when following the original
downlink.  Go read the nbtree README.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Reasons not to like asprintf
Next
From: Jaime Casanova
Date:
Subject: Re: Commitfest II CLosed