BUG #17771: add a "status" column to the pg_rules system view
От | PG Bug reporting form |
---|---|
Тема | BUG #17771: add a "status" column to the pg_rules system view |
Дата | |
Msg-id | 17771-818ce255fdbaef2c@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #17771: add a "status" column to the pg_rules system view
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 17771 Logged by: Albin Hermange Email address: albin.hermange@gmail.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
В списке pgsql-bugs по дате отправления: