Re: unexpected default ACL type 83

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>
To: Shigeru Hanada <hanada@metrosystems.co.jp>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-04-21T02:26:43Z
Lists: pgsql-hackers
On Wed, Apr 20, 2011 at 7:34 AM, Shigeru Hanada
<hanada@metrosystems.co.jp> wrote:
> 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.

Nice catch.  Committed and back-patched to 9.0.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company