Thread: [COMMITTERS] pgsql: Improve RLS documentation with respect to COPY

[COMMITTERS] pgsql: Improve RLS documentation with respect to COPY

From
Joe Conway
Date:
Improve RLS documentation with respect to COPY

Documentation for pg_restore said COPY TO does not support row security
when in fact it should say COPY FROM. Fix that.

While at it, make it clear that "COPY FROM" does not allow RLS to be
enabled and INSERT should be used instead. Also that SELECT policies
will apply to COPY TO statements.

Back-patch to 9.5 where RLS first appeared.

Author: Joe Conway
Reviewed-By: Dean Rasheed and Robert Haas
Discussion: https://postgr.es/m/5744FA24.3030008%40joeconway.com

Branch
------
REL9_6_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/51e9df7a1005fc7748c71cd359431f2a41ea678d

Modified Files
--------------
doc/src/sgml/ref/copy.sgml       | 9 +++++++++
doc/src/sgml/ref/pg_dump.sgml    | 5 +++++
doc/src/sgml/ref/pg_restore.sgml | 2 +-
3 files changed, 15 insertions(+), 1 deletion(-)