Make RLS work with UPDATE ... WHERE CURRENT OF
Joe Conway <mail@joeconway.com>
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.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/optimizer/path/allpaths.c | modified | +40 −0 |
| src/backend/optimizer/util/clauses.c | modified | +10 −0 |
| src/test/regress/expected/rowsecurity.out | modified | +107 −0 |
| src/test/regress/sql/rowsecurity.sql | modified | +49 −0 |