agora inbox for pgsql-committers@postgresql.org  
help / color / mirror / Atom feed
From: Jeff Davis <jdavis@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: For subscription DDL, demote user mapping checks to WARNING.
Date: Wed, 05 Aug 2026 20:26:31 +0000
Message-ID: <E1wriC7-00000000LHI-0Czu@gemulon.postgresql.org> (raw)

For subscription DDL, demote user mapping checks to WARNING.

The checks are useful to report to the user, but there's no reason to
raise an error. If needed while constructing conninfo, fdwconnection
will raise an error then.

Partially addresses finding 1, and addresses finding 13 in report from
the linked discussion.

Reported-by: Noah Misch <noah@leadboat.com>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Discussion: https://postgr.es/m/20260710195902.4f.noahmisch%40microsoft.com
Discussion: https://postgr.es/m/e103ae8daf74485e0c0ebde297fae735d38f54d1.camel@j-davis.com
Backpatch-through: 19

Branch
------
REL_19_STABLE

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

Modified Files
--------------
src/backend/commands/subscriptioncmds.c    |  8 ++++----
src/backend/foreign/foreign.c              | 14 +++++++++++++-
src/include/foreign/foreign.h              |  1 +
src/test/regress/expected/subscription.out |  8 +++-----
src/test/regress/sql/subscription.sql      |  5 +----
5 files changed, 22 insertions(+), 14 deletions(-)



view thread (2+ messages)

Message-ID: <E1wriC7-00000000LHI-0Czu@gemulon.postgresql.org>
Permalink:  ../E1wriC7-00000000LHI-0Czu@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1wriC7-00000000LHI-0Czu@gemulon.postgresql.org

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: jdavis@postgresql.org, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: For subscription DDL, demote user mapping checks to WARNING.
  In-Reply-To: <E1wriC7-00000000LHI-0Czu@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox