pgsql: Improve CREATE POLICY documentation - Mailing list pgsql-committers

From Stephen Frost
Subject pgsql: Improve CREATE POLICY documentation
Date
Msg-id E1a8rDR-00022p-88@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Improve CREATE POLICY documentation

Clarify that SELECT policies are now applied when SELECT rights
are required for a given query, even if the query is an UPDATE or
DELETE query.  Pointed out by Noah.

Additionally, note the risk regarding concurrently open transactions
where a relation which controls access to the rows of another relation
are updated and the rows of the primary relation are also being
modified.  Pointed out by Peter Geoghegan.

Back-patch to 9.5.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/43cd468cf01007f39312af05c4c92ceb6de8afd8

Modified Files
--------------
doc/src/sgml/ref/create_policy.sgml |  113 ++++++++++++++++++++++++++---------
1 file changed, 86 insertions(+), 27 deletions(-)


pgsql-committers by date:

Previous
From: Stephen Frost
Date:
Subject: pgsql: Collect the global OR of hasRowSecurity flags for plancache
Next
From: Stephen Frost
Date:
Subject: pgsql: Improve CREATE POLICY documentation