Re: UPDATE of partition key

From: Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>
To: Amit Khandekar <amitdkhan(dot)pg(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: UPDATE of partition key
Date: 2017-08-07 06:24:40
Message-ID: CAKcux6nvXvfZ8O0BV=MF4imCyezjjWWP5=Ngkh3d01TKsT04oA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Aug 4, 2017 at 10:28 PM, Amit Khandekar <amitdkhan(dot)pg(at)gmail(dot)com>
wrote:

> >
> > Below are the TODOS at this point :
> >
> > Fix for bug reported by Rajkumar about update with join.
>
> I had explained the root issue of this bug here : [1]
>
> Attached patch includes the fix, which is explained below.
>

Hi Amit,

I have applied v14 patch and tested from my side, everything looks good to
me. attaching some of test case and out file for reference.

Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation

Attachment Content-Type Size
update_partition_test.out application/octet-stream 64.4 KB
update_partition_test.sql text/x-sql 25.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Андрей Бородин 2017-08-07 06:30:57 Adding hook in BufferSync for backup purposes
Previous Message Etsuro Fujita 2017-08-07 06:22:30 Re: Tuple-routing for certain partitioned tables not working as expected