oid
|
oid
|
Row identifier (hidden attribute, which must be specified)
|
rulename
|
name
|
Rule name
|
ev_class
|
oid
|
Name of the table that uses the rule
|
ev_attr
|
smallint
|
Column to which this rule applies (always 0 to indicate the entire table)
|
ev_type
|
"char"
|
Event type for the rule - 1 = SELECT
- 2 = UPDATE
- 3 = INSERT
- 4 = DELETE
|
ev_enabled
|
"char"
|
Controls the mode in which the rule is triggered. - O: The rule is triggered in origin and local modes.
- D: The rule is disabled.
- R: The rule is triggered in replica mode.
- A: The rule is always triggered.
|
is_instead
|
boolean
|
The value is true if the rule is of the INSTEAD type.
|
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
|