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

From Stephen Frost
Subject pgsql: Improve CREATE POLICY documentation
Date
Msg-id E1a8rDR-00022q-8D@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
------
REL9_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/46ae55c372761af5e02082ea934bebcba98040a4

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: Improve CREATE POLICY documentation
Next
From: Robert Haas
Date:
Subject: pgsql: Provide a way to predefine LWLock tranche IDs.