From: Laurenz Albe <laurenz.albe@cybertec.at>
To: joosthelberg@gmail.com
To: pgsql-docs@lists.postgresql.org
Subject: Re: create rule
Date: Fri, 03 Sep 2021 15:28:33 +0200
Message-ID: <936ab0d51b6ab2c83b7021bd0552ac096b952eca.camel@cybertec.at> (raw)
In-Reply-To: <163065867426.693.13530965660326653108@wrigleys.postgresql.org>
References: <163065867426.693.13530965660326653108@wrigleys.postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: laurenz.albe@cybertec.at, joosthelberg@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: create rule
In-Reply-To: <936ab0d51b6ab2c83b7021bd0552ac096b952eca.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox