CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc.

From: Noah Misch <noah(at)leadboat(dot)com>
To: pgsql(at)j-davis(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc.
Date: 2026-07-10 19:59:02
Message-ID: 20260710195902.4f.noahmisch@microsoft.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

An Opus 4.8 review of commit 8185bb5 found two pg_dump+restore failure
scenarios, visible in the attached test patch. (The patch also tests a
REASSIGN OWNED finding, for which I started a distinct thread
postgr.es/m/flat/20260710192533(dot)4f(dot)noahmisch(at)microsoft(dot)com).

Opus also emitted the attached report about these findings and others. I
didn't examine the others closely. Finding-19, about invalidation callbacks,
stood out as perhaps most exciting if true.

Attachment Content-Type Size
test-subscription-server-v0.patch text/plain 12.1 KB
8185bb5-subscription-server.md text/plain 23.5 KB

Browse pgsql-hackers by date

  From Date Subject
Previous Message Noah Misch 2026-07-10 19:25:33 REASSIGN OWNED vs. relisshared dep on !relisshared