Re: BUG #15832: COPY into a partitioned table breaks its indexes

From: Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>
To: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Cc: harukat(at)sraoss(dot)co(dot)jp, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: BUG #15832: COPY into a partitioned table breaks its indexes
Date: 2019-06-05 06:57:14
Message-ID: CAE9k0PmxLVywGM0BzbQzQY7UAmozJZ7dUT3ye1a1VjWkR85hyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Jun 5, 2019 at 12:11 PM David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
wrote:

> On Tue, 4 Jun 2019 at 21:20, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>
> wrote:
> > Attached patch fixes the issue. It basically updates
> estate->es_result_relation_info with the correct resultRelInfo in
> CopyMultiInsertBufferFlush(). 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.
>

Thank you.

--
With Regards,
Ashutosh Sharma
EnterpriseDB:*http://www.enterprisedb.com <http://www.enterprisedb.com/>*

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Juan José Santamaría Flecha 2019-06-05 07:29:21 Re: BUG #15789: libpq compilation with OpenSSL 1.1.1b fails on Windows with Visual Studio 2017
Previous Message David Rowley 2019-06-05 06:41:00 Re: BUG #15832: COPY into a partitioned table breaks its indexes