On Fri, 2021-09-03 at 08:44 +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/rules-views.html > Description: > > Nowhere in the documentation is mentioned that rules can only be made on > tables without dropped columns and, much to my suprise, on empty tables > only. I wanted to use rules on existing tables to cater for > column-redaction, but this seems only possible by creating a new (empty) > table for all user to use and to hide the original table from everyone. > 1. the documentation should state this (and not start with an example of use > of rules in views, which is a special case, I though). > 2. the implementation should fix the only-on-empty tables issue (avoiding > having to change the documentation).
I just tried, and both rules on columns with dropped columns and rules on non-empty tables can be created and used without problems. Perhaps you are using a mutilated fork of PostgreSQL. Yours, Laurenz Albe
