Re: BUG #14150: Attempted to delete invisible tuple - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: BUG #14150: Attempted to delete invisible tuple
Date
Msg-id CAM3SWZTvq+rQSSGo3Y8Gx5+fUETnRY3BSbDtzn_Oq6Lu2SKw4g@mail.gmail.com
Whole thread Raw
In response to Re: BUG #14150: Attempted to delete invisible tuple  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
On Sun, Jul 31, 2016 at 3:31 PM, Andres Freund <andres@anarazel.de> wrote:
> An expression index over a function acquiring a lock looks like it
> should do the trick.

Wouldn't even that hinge upon the function knowing if it was called in
the precheck path rather than the insertion path? I think that that
might be possible, but offhand it seems messy.

> Are you looking in writing an updated patch? It seems we're on one page
> of the rough direction.

I could do that. I'll look into whether or not what you describe is
really practicable in the next couple of days. It's not obvious to me
that it is right now, although I do certainly agree that it's worth a
shot.

I think that Oskari's patch was basically solid, concerns already listed aside.

--
Peter Geoghegan

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #14150: Attempted to delete invisible tuple
Next
From: amdjachenko@gmail.com
Date:
Subject: BUG #14271: Please fix 13804 bug