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

From: calebmeredith8(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13780: Multiple commands not allowed for creating a policy.
Date: 2015-11-22 13:23:27
Message-ID: 20151122132327.1832.52687@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13780
Logged by: Caleb Meredith
Email address: calebmeredith8(at)gmail(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2015-11-23 12:16:15 Re: BUG #13780: Multiple commands not allowed for creating a policy.
Previous Message Tom Lane 2015-11-21 20:58:41 Re: Confusing error message with too-large file in pg_basebackup