pgsql: Fix RLS with COPY (col1, col2) FROM tab
От | Stephen Frost |
---|---|
Тема | pgsql: Fix RLS with COPY (col1, col2) FROM tab |
Дата | |
Msg-id | E1br9mW-0005CB-Dd@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Fix RLS with COPY (col1, col2) FROM tab Attempting to COPY a subset of columns from a table with RLS enabled would fail due to an invalid query being constructed (using a single ColumnRef with the list of fields to exact in 'fields', but that's for the different levels of an indirection for a single column, not for specifying multiple columns). Correct by building a ColumnRef and then RestTarget for each column being requested and then adding those to the targetList for the select query. Include regression tests to hopefully catch if this is broken again in the future. Patch-By: Adam Brightwell Reviewed-By: Michael Paquier Branch ------ REL9_5_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/647a86e374d2eb01d8cdda2fc759a770b38cc232 Modified Files -------------- src/backend/commands/copy.c | 63 ++++++++++++++++++++++++------ src/test/regress/expected/copy2.out | 78 +++++++++++++++++++++++++++++++++++++ src/test/regress/sql/copy2.sql | 63 ++++++++++++++++++++++++++++++ 3 files changed, 192 insertions(+), 12 deletions(-)
В списке pgsql-committers по дате отправления: