pgsql: For REASSIGN OWNED for foreign user mappings - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: For REASSIGN OWNED for foreign user mappings
Date
Msg-id E1a7VWG-0005rg-58@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
For REASSIGN OWNED for foreign user mappings

As reported in bug #13809 by Alexander Ashurkov, the code for REASSIGN
OWNED hadn't gotten word about user mappings.  Deal with them in the
same way default ACLs do, which is to ignore them altogether; they are
handled just fine by DROP OWNED.  The other foreign object cases are
already handled correctly by both commands.

Also add a REASSIGN OWNED statement to foreign_data test to exercise the
foreign data objects.  (The changes are just before the "cleanup" phase,
so it shouldn't remove any existing live test.)

Reported by Alexander Ashurkov, then independently by Jaime Casanova.

Branch
------
REL9_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/f44c5203b741ed2f188a9e58b62e93c8c47e9bb4

Modified Files
--------------
src/backend/catalog/pg_shdepend.c          |    5 +++++
src/test/regress/expected/foreign_data.out |   14 ++++++++------
src/test/regress/sql/foreign_data.sql      |    7 +++++--
3 files changed, 18 insertions(+), 8 deletions(-)


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pgsql: For REASSIGN OWNED for foreign user mappings
Next
From: Alvaro Herrera
Date:
Subject: pgsql: For REASSIGN OWNED for foreign user mappings