diff options
| -rw-r--r-- | doc/src/sgml/event-trigger.sgml | 5 | ||||
| -rw-r--r-- | doc/src/sgml/func.sgml | 8 | ||||
| -rw-r--r-- | src/include/commands/event_trigger.h | 6 |
3 files changed, 17 insertions, 2 deletions
diff --git a/doc/src/sgml/event-trigger.sgml b/doc/src/sgml/event-trigger.sgml index 3b6a5361b34..ff369bed19f 100644 --- a/doc/src/sgml/event-trigger.sgml +++ b/doc/src/sgml/event-trigger.sgml @@ -80,6 +80,11 @@ control statements are available to rewrite a table, like <literal>CLUSTER</literal> and <literal>VACUUM</literal>, the <literal>table_rewrite</literal> event is not triggered by them. + To find the OID of the table that was rewritten, use the function + <literal>pg_event_trigger_table_rewrite_oid()</literal> (see + <xref linkend="functions-event-triggers"/>). To discover the reason(s) + for the rewrite, use the function + <literal>pg_event_trigger_table_rewrite_reason()</literal>. </para> <para> diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 4812dd76405..40849d9788e 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -28357,8 +28357,12 @@ CREATE EVENT TRIGGER test_event_trigger_for_drops <returnvalue>integer</returnvalue> </para> <para> - Returns a code explaining the reason(s) for rewriting. The exact - meaning of the codes is release dependent. + Returns a code explaining the reason(s) for rewriting. The value is + a bitmap built from the following values: <literal>1</literal> + (the table has changed its persistence), <literal>2</literal> + (default value of a column has changed), <literal>4</literal> + (a column has a new data type) and <literal>8</literal> + (the table access method has changed). </para></entry> </row> </tbody> diff --git a/src/include/commands/event_trigger.h b/src/include/commands/event_trigger.h index 10091c3aafd..321e6a6ca07 100644 --- a/src/include/commands/event_trigger.h +++ b/src/include/commands/event_trigger.h @@ -29,6 +29,12 @@ typedef struct EventTriggerData CommandTag tag; } EventTriggerData; +/* + * Reasons for relation rewrites. + * + * pg_event_trigger_table_rewrite_reason() uses these values, so make sure to + * update the documentation when changing this list. + */ #define AT_REWRITE_ALTER_PERSISTENCE 0x01 #define AT_REWRITE_DEFAULT_VAL 0x02 #define AT_REWRITE_COLUMN_REWRITE 0x04 |