Обсуждение: RLS syntax

Поиск
Список
Период
Сортировка

RLS syntax

От
Craig Ringer
Дата:
[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