Postgres Pro
Downloads
Home   >   mailing lists

Re: "insert [...] on conflict" hangs on conflict on an unmentioned gist index - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: "insert [...] on conflict" hangs on conflict on an unmentioned gist index
Date
Msg-id CAM3SWZSfw0yrpmUBm7KC6gQf4N1nSLnXyodD3zxOOVkVB9bMHg@mail.gmail.com
Whole thread Raw
In response to Re: "insert [...] on conflict" hangs on conflict on an unmentioned gist index  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: "insert [...] on conflict" hangs on conflict on an unmentioned gist index
List pgsql-bugs
Tree view 
On Mon, Jul 4, 2016 at 9:38 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Nah, I take that back --- I was expecting this to be handled somewhere
> else than it is.  It looks like the actual cause is just sloppy
> handling of noDupErr in ExecInsertIndexTuples; the attached fixes it
> for me.

I agree that that's all this was; it's uncommon to specify an
exclusion constraint by name with DO NOTHING, so we didn't catch this
until now.

Thanks for looking into this.

--
Peter Geoghegan

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: "insert [...] on conflict" hangs on conflict on an unmentioned gist index
Next
From: Heikki Rauhala
Date:
Subject: Re: "insert [...] on conflict" hangs on conflict on an unmentioned gist index