Обсуждение: unexpected default ACL type 83

Поиск
Список
Период
Сортировка

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
Вложения

Re: unexpected default ACL type 83

От
Robert Haas
Дата:
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