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: | [email protected] |
Views: | Whole Thread | Raw Message | 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/[email protected]
Branch
------
REL_10_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/406df42a5f6d7139df50f190cb7845418f9c0cfa
Modified Files
--------------
doc/src/sgml/ddl.sgml | 42 +++++++++++++++++++++++++++++++++---------
1 file changed, 33 insertions(+), 9 deletions(-)
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 |