RE: No-op updates with partitioning and logical replication started failing in version 13

Zhijie Hou (Fujitsu) <houzj.fnst@fujitsu.com>

From: "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>

To: Amit Kapila <amit.kapila16@gmail.com>

Cc: Peter Smith <smithpb2250@gmail.com>, Brad Nicholson <brad.nicholson@instacart.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>, Amit Langote <amitlangote09@gmail.com>

Date: 2022-08-16T07:49:16Z

Lists: pgsql-bugs

Attachments

v3-0001-PG15-fix-RI-check-for-partitioned-table.patch (application/octet-stream) patch v3-0001
v3-0001-PG13-fix-RI-check-for-partitioned-table.patch (application/octet-stream) patch v3-0001
v3-0001-PG14-fix-RI-check-for-partitioned-table.patch (application/octet-stream) patch v3-0001
v3-0001-HEAD-fix-RI-check-for-partitioned-table.patch (application/octet-stream) patch v3-0001

On Tuesday, August 16, 2022 2:58 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> 
> On Mon, Aug 15, 2022 at 11:07 AM houzj.fnst@fujitsu.com
> <houzj.fnst@fujitsu.com> wrote:
> >
> > Attach the new version patch which improved the comments and commit
> > messages.
> >
> 
> Thanks, the patch looks good to me. Can you please prepare back branch
> patches unless you or someone else sees a reason not to back patch this?

OK, here are the patches for HEAD ~ PG13.
I have confirmed that the problem is fixed after applying the patch on both
HEAD And back branches.

Best regards,
Hou zj

Commits

Fix replica identity check for a partitioned table.
- 0d5bd3a6cc3e 16.0 landed
- 76d257925994 15.0 landed
- 02f8d68af256 14.6 landed
- 1df86aac517d 13.9 landed
Fix plan created for inherited UPDATE/DELETE with all tables excluded.
- ab5fcf2b04f9 12.0 cited