From 533073cf2321bb9fd3ec983443e41b7040f2771b Mon Sep 17 00:00:00 2001 From: Heikki Linnakangas Date: Fri, 12 Nov 2010 15:19:14 +0200 Subject: [PATCH] Add missing support for removing foreign data wrapper / server privileges belonging to a user at DROP OWNED BY. Foreign data wrappers and servers don't do anything useful yet, which is why no-one has noticed, but since we have them, seems prudent to fix this. Per report from Chetan Suttraway. Backpatch to 9.0, 8.4 has the same problem but this patch didn't apply there so I'm not going to bother. --- src/backend/catalog/aclchk.c | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/src/backend/catalog/aclchk.c b/src/backend/catalog/aclchk.c index 0470a70273..9b5602ed00 100644 --- a/src/backend/catalog/aclchk.c +++ b/src/backend/catalog/aclchk.c @@ -1386,6 +1386,12 @@ RemoveRoleFromObjectACL(Oid roleid, Oid classid, Oid objid) case TableSpaceRelationId: istmt.objtype = ACL_OBJECT_TABLESPACE; break; + case ForeignServerRelationId: + istmt.objtype = ACL_OBJECT_FOREIGN_SERVER; + break; + case ForeignDataWrapperRelationId: + istmt.objtype = ACL_OBJECT_FDW; + break; default: elog(ERROR, "unexpected object class %u", classid); break; -- 2.40.0