v1-0001-Fix-version-check-for-retain_dead_tuples-subscrip.patch
application/octet-stream
Filename: v1-0001-Fix-version-check-for-retain_dead_tuples-subscrip.patch
Type: application/octet-stream
Part: 0
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch v1-0001
Subject: Fix version check for retain_dead_tuples subscription option.
| File | + | − |
|---|---|---|
| src/backend/commands/subscriptioncmds.c | 1 | 1 |
From 7b2869702af0cde3182a58bf2677b156bab1ec76 Mon Sep 17 00:00:00 2001
From: Fujii Masao <fujii@postgresql.org>
Date: Tue, 23 Dec 2025 01:25:41 +0900
Subject: [PATCH v1 1/2] Fix version check for retain_dead_tuples subscription
option.
The retain_dead_tuples subscription option is supported only when
the publisher runs PostgreSQL 19 or later. However, it could previously
be enabled even when the publisher was running an earlier version.
This was caused by check_pub_dead_tuple_retention() comparing
the publisher server version against 19000 instead of 190000.
Fix this typo so that the version check correctly enforces the PG19+
requirement.
---
src/backend/commands/subscriptioncmds.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/src/backend/commands/subscriptioncmds.c b/src/backend/commands/subscriptioncmds.c
index abbcaff0838..f023dcbd6ad 100644
--- a/src/backend/commands/subscriptioncmds.c
+++ b/src/backend/commands/subscriptioncmds.c
@@ -2753,7 +2753,7 @@ check_pub_dead_tuple_retention(WalReceiverConn *wrconn)
bool isnull;
bool remote_in_recovery;
- if (walrcv_server_version(wrconn) < 19000)
+ if (walrcv_server_version(wrconn) < 190000)
ereport(ERROR,
errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
errmsg("cannot enable retain_dead_tuples if the publisher is running a version earlier than PostgreSQL 19"));
--
2.51.2