diff options
| -rw-r--r-- | doc/src/sgml/event-trigger.sgml | 5 | ||||
| -rw-r--r-- | doc/src/sgml/func.sgml | 7 | ||||
| -rw-r--r-- | src/include/commands/event_trigger.h | 6 |
3 files changed, 16 insertions, 2 deletions
diff --git a/doc/src/sgml/event-trigger.sgml b/doc/src/sgml/event-trigger.sgml index a76e8ac09be..8cf4691fa41 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 21e0a3b74eb..bba45c5e302 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -26786,8 +26786,11 @@ 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) and <literal>4</literal> + (a column has a new data type). </para></entry> </row> </tbody> diff --git a/src/include/commands/event_trigger.h b/src/include/commands/event_trigger.h index 28b352051b9..8b740807f86 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 |