pgsql: Revert "Validate subscription conninfo on owner change"

From: Jeff Davis <jdavis(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Revert "Validate subscription conninfo on owner change"
Date: 2026-08-05 20:26:27
Message-ID: E1wriC3-00000000LGE-3tvJ@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Revert "Validate subscription conninfo on owner change"

This reverts commit 1c9c35890421e96a91129b51f2c6446a6d95af95.

Raising errors during OWNER TO can cause problems during restore. An
upcoming commit will avoid other errors that can happen in this path.

Reviewed-by: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Discussion: https://postgr.es/m/e103ae8daf74485e0c0ebde297fae735d38f54d1.camel@j-davis.com
Backpatch-through: 19

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ac230cd3ce93c4752489564cfe6b37b584a465ac

Modified Files
--------------
doc/src/sgml/ref/alter_subscription.sgml | 7 -------
src/backend/commands/subscriptioncmds.c | 14 ++------------
src/test/regress/expected/subscription.out | 17 -----------------
src/test/regress/regress.c | 9 ---------
src/test/regress/sql/subscription.sql | 15 ---------------
5 files changed, 2 insertions(+), 60 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Jeff Davis 2026-08-05 20:26:31 pgsql: Always check foreign-server USAGE when resolving subscription co
Previous Message Jeff Davis 2026-08-05 20:14:10 pgsql: Be precise about when ALTER SUBSCRIPTION needs conninfo.