Improve CREATE POLICY documentation

Stephen Frost <sfrost@snowman.net>

Commit: 43cd468cf01007f39312af05c4c92ceb6de8afd8
Author: Stephen Frost <sfrost@snowman.net>
Date: 2015-12-15T15:08:09Z
Releases: 9.6.0
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.

Files

PathChange+/−
doc/src/sgml/ref/create_policy.sgml modified +86 −27

Documentation touched