Re: [PATCH v1] Fix initial sync of zero-column published tables

From: mingjiegao <mingjie(dot)gmj(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH v1] Fix initial sync of zero-column published tables
Date: 2026-11-02 02:37:02
Message-ID: CAL5_ZS2fg7wAiN-zOA8Qg9xGJA7mJsTPK=MJV=cfAr2g-7rzAQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I've attached lr02.sql, a minimal psql reproducer for this issue in
text mode (binary = false). It uses separate publisher and subscriber
databases in the same instance.

On an affected build, the initial COPY row gets an empty string
instead of the subscriber's default, while a subsequent incremental
INSERT uses the default correctly.

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
lr02.sql text/plain 2.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tianyi Gao 2026-11-02 02:41:20 Re: Use a hash table for the regexp cache
Previous Message mingjiegao 2026-11-02 02:36:56 Re: [PATCH] Fix incorrect logical replication updates with a shared leaf partition