pgsql: Handle append_rel_list in expand_security_qual - Mailing list pgsql-committers

From Stephen Frost
Subject pgsql: Handle append_rel_list in expand_security_qual
Date
Msg-id E1ZkYyz-0001a6-RZ@gemulon.postgresql.org
Whole thread Raw
List 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
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b7aac36245261eba9eb7d18561ce44220b361959

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(-)


pgsql-committers by date:

Previous
From: Stephen Frost
Date:
Subject: pgsql: Handle append_rel_list in expand_security_qual
Next
From: Thom Brown
Date:
Subject: Re: pgsql: Perform an immediate shutdown if the postmaster.pid file is remo