Message-ID: <936ab0d51b6ab2c83b7021bd0552ac096b952eca.camel@cybertec.at>
Subject: Re: create rule
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: joosthelberg@gmail.com, pgsql-docs@lists.postgresql.org
Date: Fri, 03 Sep 2021 15:28:33 +0200
In-Reply-To: <163065867426.693.13530965660326653108@wrigleys.postgresql.org>
References: <163065867426.693.13530965660326653108@wrigleys.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.40.4 (3.40.4-1.fc34) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/936ab0d51b6ab2c83b7021bd0552ac096b952eca.camel%40cybertec.at>
Precedence: bulk

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