CREATE SUBSCRIPTION: do not construct conninfo unnecessarily. Still check that the creating user has USAGE privileges on the server, and that the FDW supports subscription connections.
Addresses finding 1 in the report from the linked discussion. Reported-by: Noah Misch <[email protected]> Reviewed-by: Amit Kapila <[email protected]> Discussion: https://postgr.es/m/20260710195902.4f.noahmisch%40microsoft.com Discussion: https://postgr.es/m/[email protected] Backpatch-through: 19 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/254beb174e61e339c43e1096053b0a0a2e9cf856 Modified Files -------------- src/backend/commands/subscriptioncmds.c | 37 ++++++++++++++++++++++-------- src/backend/foreign/foreign.c | 4 ++-- src/test/regress/expected/subscription.out | 4 ++-- 3 files changed, 31 insertions(+), 14 deletions(-)
