]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Doc: fix oversimplified example for CREATE POLICY.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 30 Jul 2018 15:54:41 +0000 (11:54 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 30 Jul 2018 15:54:41 +0000 (11:54 -0400)
commit72c453d30d565de91c921c7f5e0c984c23e77df5
treeae086ab2f1aabe8d0f5f8e74f482ce7c1a9c80de
parent28a0b3a2228ba9618225d3641e978b739237f492
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
doc/src/sgml/ddl.sgml