From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | albin(dot)hermange(at)gmail(dot)com |
Subject: | BUG #17771: add a "status" column to the pg_rules system view |
Date: | 2023-02-05 16:02:58 |
Message-ID: | 17771-818ce255fdbaef2c@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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:
hi,
I noticed that the pg_rules system view (all PG versions) does not include a
"status" field (like in pg_trigger with tgenabled column)
the official view (from 15.1 sources) is :
CREATE VIEW pg_rules AS
SELECT
N.nspname AS schemaname,
C.relname AS tablename,
R.rulename AS rulename,
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';
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 ?
Thx
Albin
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2023-02-05 17:09:40 | Re: Bug Report: INSERT ON CONFLICT sometimes does not work with partial index |
Previous Message | ROCHER Julien | 2023-02-05 15:52:49 | Re: TR: Issue: --exclude-schema flag not working with pgrestore |