pgsql: Improve RLS documentation with respect to COPY

From: Joe Conway <mail(at)joeconway(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve RLS documentation with respect to COPY
Date: 2016-12-23 01:57:59
Message-ID: E1cKF7P-0001mE-BN@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/0a85c102254b72ec7ce16bc504206a1a5c84bd76

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

Browse pgsql-committers by date

  From Date Subject
Next Message Joe Conway 2016-12-23 01:58:04 pgsql: Improve RLS documentation with respect to COPY
Previous Message Tom Lane 2016-12-22 23:35:01 Re: Re: [COMMITTERS] pgsql: Build HTML documentation using XSLT stylesheets by default