postgres.git / summary / log / commit / refs

commit    533073cf2321bb9fd3ec983443e41b7040f2771b
Author:   Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date:     Fri Nov 12 13:19:14 2010 +0000
First released in: 9.1.0, 9.0.2

    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 0470a702739..9b5602ed004 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;


[parent: 9dba66c0e524]