Обсуждение: pgsql: Apply SELECT policies in INSERT/UPDATE+RETURNING

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

pgsql: Apply SELECT policies in INSERT/UPDATE+RETURNING

От
Stephen Frost
Дата:
Apply SELECT policies in INSERT/UPDATE+RETURNING

Similar to 7d8db3e, given that INSERT+RETURNING requires SELECT rights
on the table, apply the SELECT policies as WCOs to the tuples being
inserted.  Apply the same logic to UPDATE+RETURNING.

Back-patch to 9.5 where RLS was added.

Branch
------
REL9_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/bd9014768035dd70f8cc33c215a8b929c2e13a35

Modified Files
--------------
src/backend/rewrite/rowsecurity.c |   32 +++++++++++++++++++++++++++++---
1 file changed, 29 insertions(+), 3 deletions(-)


Re: pgsql: Apply SELECT policies in INSERT/UPDATE+RETURNING

От
Peter Geoghegan
Дата:
On Mon, Oct 5, 2015 at 4:55 AM, Stephen Frost <sfrost@snowman.net> wrote:
> Apply SELECT policies in INSERT/UPDATE+RETURNING

If we've changed this now, where does that leave the excluded.* pseudo-relation?

--
Peter Geoghegan