Horton

Avoid errors during ALTER SUBSCRIPTION.

Jeff Davis <jdavis@postgresql.org>

View on postgr.es
Commit: e5c40584a712e8f8c6bd9a7a87bdb855cfd2f20b
Author: Jeff Davis <jdavis@postgresql.org>
Date: 2026-06-17T22:34:07Z
Releases: 19 (unreleased) 
Avoid errors during ALTER SUBSCRIPTION.

Previously, when retrieving the old Subscription object, constructing
the conninfo could encounter an error during
ForeignServerConnectionString(). ACL errors were handled properly, but
other errors could interfere with a user fixing the problem with ALTER
SUBSCRIPTION.

Reported-by: Chao Li <li.evan.chao@gmail.com>
Reviewed-by: Chao Li <li.evan.chao@gmail.com>
Discussion: https://postgr.es/m/D908370F-2695-4231-851D-17179A6A6F2A@gmail.com

Files

PathChange+/−
src/backend/catalog/pg_subscription.c modified +41 −31
src/backend/commands/subscriptioncmds.c modified +80 −31
src/backend/replication/logical/worker.c modified +2 −2
src/include/catalog/pg_subscription.h modified +2 −1
src/test/regress/expected/subscription.out modified +25 −4
src/test/regress/regress.c modified +3 −0
src/test/regress/sql/subscription.sql modified +31 −4

Discussion