From: | Stephen Frost <sfrost(at)snowman(dot)net> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Handle append_rel_list in expand_security_qual |
Date: | 2015-10-09 14:49:17 |
Message-ID: | E1ZkYyz-0001a7-Re@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Handle append_rel_list in expand_security_qual
During expand_security_quals, we take the security barrier quals on an
RTE and create a subquery which evaluates the quals. During this, we
have to replace any variables in the outer query which refer to the
original RTE with references to the columns from the subquery.
We need to also perform that replacement for any Vars in the
append_rel_list.
Only backpatching to 9.5 as we only go through this process in 9.4 for
auto-updatable security barrier views, which UNION ALL queries aren't.
Discovered by Haribabu Kommi
Patch by Dean Rasheed
Branch
------
REL9_5_STABLE
Details
-------
http://git.postgresql.org/pg/commitdiff/a26609e470601421b44424d6cc2683c4acabd086
Modified Files
--------------
src/backend/optimizer/prep/prepsecurity.c | 11 ++++++++++-
src/test/regress/expected/rowsecurity.out | 20 ++++++++++++++++++++
src/test/regress/sql/rowsecurity.sql | 4 ++++
3 files changed, 34 insertions(+), 1 deletion(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2015-10-09 14:56:40 | Re: pgsql: Perform an immediate shutdown if the postmaster.pid file is remo |
Previous Message | Tom Lane | 2015-10-09 14:12:17 | pgsql: Fix uninitialized-variable bug. |