Bug in logical decoding with DDL and subtransactions

From: Bingshuai Li <lucian1412(at)outlook(dot)com>
To: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: "mark(dot)dilger(at)enterprisedb(dot)com" <mark(dot)dilger(at)enterprisedb(dot)com>
Subject: Bug in logical decoding with DDL and subtransactions
Date: 2026-08-13 02:18:45
Message-ID: ME0P300MB0568A04EB1A13B6CC5B2253CC6DB2@ME0P300MB0568.AUSP300.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Mark,

Here is v3. The only change from v2 is in the regression test: its
scratch database is now named regression_tuplecid instead of
tuplecid_db. cfbot's autoconf task compiles with
-DENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS, and the old name tripped
the "should have names including regression" WARNING, which broke the
expected output on that task (all other cfbot tasks were green).
No code changes.

Re-verified under that exact flag locally
(CPPFLAGS=-DENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS): the
test_decoding suite passes, 21 regression + 14 isolation tests.

Thanks,
Bingshuai Li

Attachment Content-Type Size
v3-0001-Fix-stale-tuplecid-records-left-behind-by-aborted.patch application/octet-stream 25.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2026-08-13 02:41:00 Re: Add a pg_wal_preallocate() SQL function to eagerly create future WAL segments
Previous Message Amit Langote 2026-08-13 02:11:20 Re: Re-read conindid under the referenced table's lock in the RI fast path