Re: [PATCH] Fix incorrect logical replication updates with a shared leaf partition

From: mingjiegao <mingjie(dot)gmj(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH] Fix incorrect logical replication updates with a shared leaf partition
Date: 2026-11-02 02:36:56
Message-ID: CAL5_ZS3-QbcT7pKtWjsdmS__4LWeMSXe9GBv2guVzftgjmSZ5Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I've attached lr01.sql, a minimal psql reproducer for this issue. It
uses separate publisher and subscriber databases in the same instance
and waits for replication between updates.

On an affected build, the final query returns (1,111) and (222,2),
instead of (1,111) and (2,222).

Please run it on a test instance with logical replication enabled and
authentication configured for the subscription connection.

Best regards,
mingjiegao

Attachment Content-Type Size
lr01.sql text/plain 1.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message mingjiegao 2026-11-02 02:37:02 Re: [PATCH v1] Fix initial sync of zero-column published tables
Previous Message Fujii Masao 2026-11-02 02:32:58 Re: bug: query returns different result with and without memoization.