RLS syntax

Started by Craig Ringerabout 12 years ago1 messages
#1Craig Ringer
craig@2ndquadrant.com

[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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers