pgsql: For REASSIGN OWNED for foreign user mappings

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: For REASSIGN OWNED for foreign user mappings
Date: 2015-12-11 21:46:28
Message-ID: E1a7VWG-0005rW-4P@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/31f88a12a0d9e340f7ccf49e5f133835499c981b

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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2015-12-11 23:33:26 pgsql: pg_rewind: Don't error if the two clusters are already on the sa
Previous Message Tom Lane 2015-12-11 21:15:23 pgsql: Install our "missing" script where PGXS builds can find it.