Re: BUG #17771: add a "status" column to the pg_rules system view

On Sun, Feb 5, 2023 at 9:51 AM PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference: 17771
> Logged by: Albin Hermange
> Email address: albin(dot)hermange(at)gmail(dot)com
> PostgreSQL version: 15.1
> Operating system: all OS
> Description:
>
> i propose to add a new field "rule_enabled" to get (easilly and officially)
> the rule status to all PG version
>
> CREATE VIEW pg_rules AS
> SELECT
> N.nspname AS schemaname,
> C.relname AS tablename,
> R.rulename AS rulename,
> R.ev_enabled as rule_enabled,
> pg_get_ruledef(R.oid) AS definition
> FROM (pg_rewrite R JOIN pg_class C ON (C.oid = R.ev_class))
> LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
> WHERE R.rulename != '_RETURN';
>
>
> What do u think about that ?
>
>
Its absence isn't a bug - if you want to take a poll, post something to
pgsql-general, if you want to submit a patch, send it to pgsql-hackers.

David J.