Re: Fix race condition in pg_get_publication_tables with concurrent DROP TABLE

[Bharath Rupireddy]

Hi,

On Tue, Jun 30, 2026 at 10:38 AM Masahiko Sawada <sawada.m...@gmail.com> wrote:
>
> While changes to pg_get_publication_tables() look good to me,

Thanks for reviewing!

> I think
> the regression tests should be implemented as an isolation test rather
> than a TAP test in 100_bugs.pl as it can be tested without subscribers
> and the isolation test works well for this kind of race condition
> tests.

Agreed. The isolation test avoids the extra publisher start/stop the
TAP version needed, and it's about the same amount of code. Please
find the attached v9 patches.

-- 
Bharath Rupireddy
Amazon Web Services: https://aws.amazon.com

v9-0001-Fix-pg_get_publication_tables-race-with-concurren.patch
Description: Binary data

v9-0001-REL19-Fix-pg_get_publication_tables-race-with-concurrent-DROP.patch
Description: Binary data

v9-0001-REL18-Fix-pg_get_publication_tables-race-with-concurrent-DROP.patch
Description: Binary data

v9-0001-REL17-Fix-pg_get_publication_tables-race-with-concurrent-DROP.patch
Description: Binary data

v9-0001-REL16-Fix-pg_get_publication_tables-race-with-concurrent-DROP.patch
Description: Binary data