From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Make RLS work with UPDATE ... WHERE CURRENT OF |
Date: | 2015-07-24 19:57:08 |
Message-ID: | E1ZIj5g-00067z-Tn@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Make RLS work with UPDATE ... WHERE CURRENT OF
UPDATE ... WHERE CURRENT OF would not work in conjunction with
RLS. Arrange to allow the CURRENT OF expression to be pushed down.
Issue noted by Peter Geoghegan. Patch by Dean Rasheed. Back patch
to 9.5 where RLS was introduced.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/b26e3d660df51a088d14c3c2cfce5990c13c1195
Modified Files
--------------
src/backend/optimizer/path/allpaths.c | 40 +++++++++++
src/backend/optimizer/util/clauses.c | 10 +++
src/test/regress/expected/rowsecurity.out | 107 +++++++++++++++++++++++++++++
src/test/regress/sql/rowsecurity.sql | 49 +++++++++++++
4 files changed, 206 insertions(+)
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2015-07-24 19:57:19 | pgsql: Make RLS work with UPDATE ... WHERE CURRENT OF |
Previous Message | Andrew Dunstan | 2015-07-24 13:47:56 | pgsql: Fix treatment of nulls in jsonb_agg and jsonb_object_agg |