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.
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 |