pgsql: Don't record FDW user mappings as members of extensions. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Don't record FDW user mappings as members of extensions.
Date
Msg-id E1fn8fp-0007SZ-SB@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Don't record FDW user mappings as members of extensions.

CreateUserMapping has a recordDependencyOnCurrentExtension call that's
been there since extensions were introduced (very possibly my fault).
However, there's no support anywhere else for user mappings as members
of extensions, nor are they listed as a possible member object type in
the documentation.  Nor does it really seem like a good idea for user
mappings to belong to extensions when roles don't.  Hence, remove the
bogus call.

(As we saw in bug #15310, the lack of any pg_dump support for this case
ensures that any such membership record would silently disappear during
pg_upgrade.  So there's probably no need for us to do anything else
about cleaning up after this mistake.)

Discussion: https://postgr.es/m/27952.1533667213@sss.pgh.pa.us

Branch
------
REL_11_STABLE

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

Modified Files
--------------
src/backend/commands/foreigncmds.c | 8 ++++++--
1 file changed, 6 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix incorrect initialization of BackendActivityBuffer.
Next
From: pgsql@postgresql.org
Date:
Subject: pgsql: Tag refs/tags/REL9_5_14 was created