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

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: Mingjie Gao <mingjie(dot)gmj(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH v1] Fix initial sync of zero-column published tables
Date: 2026-11-05 06:41:41
Message-ID: CAHut+Pt+9S33TwA8bcnhNg02Aw58CVm4OSh8Eg3DMz5czKLTAg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Nov 5, 2026 at 1:48 PM Mingjie Gao <mingjie(dot)gmj(at)gmail(dot)com> wrote:
...
> Please find the updated v2 patch attached.
>

Some minor comments for the v2 test code.

======
src/test/subscription/t/008_diff_schema.pl

1.
+ CREATE PUBLICATION pub_nocols FOR TABLE tab_nocols
+ WITH (publish = 'insert');

Saying publish = 'insert' seems overkill.

~~~

2.
+ $node_subscriber->safe_psql('postgres', 'DROP SUBSCRIPTION sub_nocols');
+ $node_publisher->safe_psql('postgres',
+ 'DROP PUBLICATION pub_nocols; DROP TABLE tab_nocols');
+ $node_subscriber->safe_psql('postgres', 'DROP TABLE tab_nocols');

Those could be combined a bit...

~~~

3. Other misc refactoring

some spaces
some comments
some more consistent use of terminating ';'
etc.

~~~

I've made a few tmp changes (only cosmetic -- nothing functional).
e.g., see my attached version of the 008_diff_schema.pl changes for reference.

======
Kind Regards,
Peter Smith.
Fujitsu Australia

Attachment Content-Type Size
nocfbot-PS-tests.txt text/plain 2.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2026-11-05 06:43:54 Fix stale column context after COPY FROM conversion errors
Previous Message Amit Kapila 2026-11-05 06:13:29 Re: Avoid resetting subscription two_phase state to pending when already enabled