RLS syntax

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: RLS syntax
Date: 2013-10-24 03:48:56
Message-ID: 526898A8.7090309@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

[bikeshed]

I'm not totally comfortable with the details of ALTER TABLE ... SET ROW
SECURITY FOR ALL .

If you read:

ALTER TABLE document SET ROW SECURITY FOR ALL
TO (...query...)

is it obvious to you that "FOR ALL" here refers to all _command types_?

I'd like to make that more explicit and allow an OR-list of commands, so
it'd look like

FOR ALL COMMANDS TO (...)

or for specific commands, something like

FOR INSERT OR DELETE TO (...)

[/bikeshed]
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2013-10-24 03:52:16 Re: Add min and max execute statement time in pg_stat_statement
Previous Message Nigel Heron 2013-10-24 03:48:03 Re: stats for network traffic WIP