Functions / Event Trigger Functions

pg_event_trigger_table_rewrite_reason

Returns a code explaining the reason(s) for rewriting.

Reading PG 18current·documented in 13 of 27 versions, 9.5 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

pg_event_trigger_table_rewrite_reason () → integer

Returns a code explaining the reason(s) for rewriting. The value is a bitmap built from the following values: 1 (the table has changed its persistence), 2 (default value of a column has changed), 4 (a column has a new data type) and 8 (the table access method has changed).

Version history 3

13 → 14 changed
12 → 13 changed
9.4 → 9.5 added

Definition snapshot: b7bd9cda · English manual source