RLS syntax - Mailing list pgsql-hackers

From Craig Ringer
Subject RLS syntax
Date
Msg-id 526898A8.7090309@2ndquadrant.com
Whole thread Raw
List 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



pgsql-hackers by date:

Previous
From: Nigel Heron
Date:
Subject: Re: stats for network traffic WIP
Next
From: Alvaro Herrera
Date:
Subject: Re: Add min and max execute statement time in pg_stat_statement