pgsql: Apply SELECT policies in INSERT/UPDATE+RETURNING
pgsql: Apply SELECT policies in INSERT/UPDATE+RETURNING
От:
Stephen Frost <sfrost@snowman.net>
Дата:
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 <pg@heroku.com>
Дата:
On Mon, Oct 5, 2015 at 4:55 AM, Stephen Frost wrote: > Apply SELECT policies in INSERT/UPDATE+RETURNING If we've changed this now, where does that leave the excluded.* pseudo-relation? -- Peter Geoghegan