Horton

REASSIGN OWNED lacks support for FDWs

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-hackers@postgreSQL.org
Date: 2012-02-15T17:58:01Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add missing support for removing foreign data wrapper / server privileges

As per http://archives.postgresql.org/pgsql-general/2012-02/msg00304.php
there is no switch case in shdepReassignOwned for foreign data wrappers.

The obvious short-term answer (and probably the only back-patchable one)
is to add a case for that object type.  But after all the refactoring
that's been done in the general area of this type of command, I'm a bit
surprised that shdepReassignOwned still looks like this.  Can't we merge
this knowledge into someplace where it doesn't have to be maintained
separately?

			regards, tom lane