pgsql: Doc: fix oversimplified example for CREATE POLICY.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Doc: fix oversimplified example for CREATE POLICY.
Date: 2018-07-30 15:54:57
Message-ID: E1fkAVd-0005hc-0E@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Doc: fix oversimplified example for CREATE POLICY.

As written, this policy constrained only the post-image not the pre-image
of rows, meaning that users could delete other users' rows or take
ownership of such rows, contrary to what the docs claimed would happen.
We need two separate policies to achieve the documented effect.

While at it, try to explain what's happening a bit more fully.

Per report from Олег Самойлов. Back-patch to 9.5 where this was added.
Thanks to Stephen Frost for off-list discussion.

Discussion: https://postgr.es/m/3298321532002010@sas1-2b3c3045b736.qloud-c.yandex.net

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/506bbbf02e8c045b6d35dc3b0083e5a12f7b3837

Modified Files
--------------
doc/src/sgml/ddl.sgml | 36 ++++++++++++++++++++++++++++++------
1 file changed, 30 insertions(+), 6 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Goldshteyn 2018-07-30 16:28:28 Re: Would like to help with documentation for Postgres 11
Previous Message Peter Eisentraut 2018-07-30 12:40:35 Re: Tips on committing