[HACKERS] unexpected default ACL type 83

[Shigeru Hanada]

I found that DROP OWNED BY can cause $SUBJECT.

How to reproduce the error:

----
CREATE USER foo;
ALTER DEFAULT PRIVILEGES GRANT ALL ON SEQUENCES TO foo;
DROP OWNED BY foo;
----

Attached patch would fix this issue.

Regards,
--
Shigeru Hanada

diff --git a/src/backend/catalog/aclchk.c b/src/backend/catalog/aclchk.c
index 693b634..db58ec2 100644
*** a/src/backend/catalog/aclchk.c
--- b/src/backend/catalog/aclchk.c
*************** RemoveRoleFromObjectACL(Oid roleid, Oid 
*** 1299,1305 ****
                        case DEFACLOBJ_RELATION:
                                iacls.objtype = ACL_OBJECT_RELATION;
                                break;
!                       case ACL_OBJECT_SEQUENCE:
                                iacls.objtype = ACL_OBJECT_SEQUENCE;
                                break;
                        case DEFACLOBJ_FUNCTION:
--- 1299,1305 ----
                        case DEFACLOBJ_RELATION:
                                iacls.objtype = ACL_OBJECT_RELATION;
                                break;
!                       case DEFACLOBJ_SEQUENCE:
                                iacls.objtype = ACL_OBJECT_SEQUENCE;
                                break;
                        case DEFACLOBJ_FUNCTION:

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers