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