| 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:19 |
| Message-ID: | E1ZIj5r-00068L-Qt@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
------
REL9_5_STABLE
Details
-------
http://git.postgresql.org/pg/commitdiff/7d4240d6cd91d83d263a45501cc2f44fb1d0a537
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 | Tom Lane | 2015-07-25 18:39:45 | pgsql: Redesign tablesample method API, and do extensive code review. |
| Previous Message | Joe Conway | 2015-07-24 19:57:08 | pgsql: Make RLS work with UPDATE ... WHERE CURRENT OF |