pgsql: Doc: update CREATE RULE ref page's hoary discussion of views. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Doc: update CREATE RULE ref page's hoary discussion of views.
Date
Msg-id E1qywPW-003lIj-HD@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Doc: update CREATE RULE ref page's hoary discussion of views.

This text left one with the impression that an ON SELECT rule could
be attached to a plain table, which has not been true since commit
264c06820 (meaning the text was already misleading when written,
evidently by me in 96bd67f61).  However, it didn't get really bad
until b23cd185f removed the convert-a-table-to-a-view logic, which
had made it possible for scripts that thought they were attaching
ON SELECTs to tables to still work.

Rewrite into a form that makes it clear that an ON SELECT rule
is better regarded as an implementation detail of a view.
Pre-v16, point out that adding ON SELECT to a table actually
converts it to a view.

Per bug #18178 from Joshua Uyehara.  Back-patch to all supported
branches.

Discussion: https://postgr.es/m/18178-05534d7064044d2d@postgresql.org

Branch
------
REL_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/9d4ea0bb3fd461164b061f19885d565cfcf57f93

Modified Files
--------------
doc/src/sgml/ref/create_rule.sgml | 19 ++++++++++---------
1 file changed, 10 insertions(+), 9 deletions(-)


pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: pgsql: doc: ALTER DEFAULT PRIVILEGES does not affect inherited roles
Next
From: Tom Lane
Date:
Subject: pgsql: Doc: update CREATE RULE ref page's hoary discussion of views.