Re: Promise index tuples for UPSERT

On 10/03/2014 01:05 PM, Peter Geoghegan wrote:
> On Fri, Oct 3, 2014 at 3:04 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> Is there a test case that demonstrates the problem?
>
> Yes. See my e-mail to Heikki here:
>
> http://www.postgresql.org/message-id/CAM3SWZShbE29KpoD44cVc3vpZJGmDer6k_6FGHiSzeOZGmTFSQ@mail.gmail.com
>
> Testcase is attached.

Simon's approach would actually pass that test case just fine. It 
inserts the (promise) index tuple first, and heap tuple only after that. 
It will fail the test case with more than one unique index, however.

- Heikki