Thread

1. unexpected default ACL type 83

   花田 茂 <hanada@metrosystems.co.jp> — 2011-04-20T11:34:56Z

   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
   

2. Re: unexpected default ACL type 83

   Robert Haas <robertmhaas@gmail.com> — 2011-04-21T02:26:43Z

   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