Re: BUG #15832: COPY into a partitioned table breaks its indexes - Mailing list pgsql-bugs

From David Rowley
Subject Re: BUG #15832: COPY into a partitioned table breaks its indexes
Date
Msg-id CAKJS1f-5K-Fvsu4aXgW=9KsiB=gWYSP2uPOj4w_1SiPUtkQsdg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15832: COPY into a partitioned table breaks its indexes  (Ashutosh Sharma <ashu.coek88@gmail.com>)
Responses Re: BUG #15832: COPY into a partitioned table breaks its indexes
List pgsql-bugs
On Tue, 4 Jun 2019 at 21:20, Ashutosh Sharma <ashu.coek88@gmail.com> wrote:
> Attached patch fixes the issue. It basically updates estate->es_result_relation_info with the correct resultRelInfo
inCopyMultiInsertBufferFlush(). I've also added the test-case for it.
 
>
> Andres, David, do you all agree with above analysis and the proposed fix ?

Thanks for the report Haruka and for the patch Ashutosh.

I've pushed this after changing the tests a little to reuse the
existing table. I also added an Assert into ExecInsertIndexTuples to
ensure the slot and the ResultRelInfo belong to the same relation. If
that had existing when this was being developed then I'd have noticed
the problem when testing it during dev.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services



pgsql-bugs by date:

Previous
From: Ashutosh Sharma
Date:
Subject: Re: BUG #15832: COPY into a partitioned table breaks its indexes
Next
From: Ashutosh Sharma
Date:
Subject: Re: BUG #15832: COPY into a partitioned table breaks its indexes