Re: create rule

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