BUG #13780: Multiple commands not allowed for creating a policy.

Поиск
Список
Период
Сортировка
От calebmeredith8@gmail.com
Тема BUG #13780: Multiple commands not allowed for creating a policy.
Дата
Msg-id 20151122132327.1832.52687@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13780: Multiple commands not allowed for creating a policy.
Re: BUG #13780: Multiple commands not allowed for creating a policy.
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13780
Logged by:          Caleb Meredith
Email address:      calebmeredith8@gmail.com
PostgreSQL version: 9.5beta1
Operating system:   OSX
Description:

When performing a grant I can do:

    GRANT INSERT, UPDATE, DELETE ON TABLE person TO user;

But when creating a policy I can't do:

    CREATE POLICY user_write ON person FOR INSERT, UPDATE, DELETE TO user
      USING (…);

The specific error is:

    ERROR:  syntax error at or near ","
    LINE 1: ...TE POLICY user_write ON person FOR INSERT, UPDATE, ...

This doesn't seem to be intended as the GRANT specification allows it, and
CREATE POLICY supports the ALL command.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Confusing error message with too-large file in pg_basebackup
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #13780: Multiple commands not allowed for creating a policy.