vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_04_0614.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

8.0 KiB
Raw Permalink Blame History

PG_REWRITE

PG_REWRITE records rewrite rules defined for tables and views.

Table 1 PG_REWRITE columns

Name

Type

Description

rulename

name

Name of the rule

ev_class

oid

Name of the table that uses the rule

ev_attr

smallint

Field to which the rule applies. Currently, the value is 0, indicating the entire table.

ev_type

"char"

Event type for this rule:

  • 1 = SELECT
  • 2 = UPDATE
  • 3 = INSERT
  • 4 = DELETE

ev_enabled

"char"

Controls in which mode the rule fires

  • O: The rule fires in "origin" and "local" modes.
  • D: The rule is disabled.
  • R: The rule fires in "replica" mode.
  • A: The rule always fires.

is_instead

boolean

Its value is true if the rule is an INSTEAD rule.

ev_qual

pg_node_tree

Expression tree (in the form of a nodeToString() representation) for the rule's qualifying condition

ev_action

pg_node_tree

Query tree (in the form of a nodeToString() representation) for the rule's action
Parent topic: System Catalogs