diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-03-18 18:58:05 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-03-18 18:58:05 -0300 |
| commit | 487e9861d0cf83e9100ad0d0369147db3ef4ea73 (patch) | |
| tree | f3cc3f4e8c89154a4d12800c1d4df86ca0161cc3 /doc/src | |
| parent | b029395f5e616e0f2b1131b2c7ecb6640f30c055 (diff) | |
| download | postgresql-487e9861d0cf83e9100ad0d0369147db3ef4ea73.tar.gz postgresql-487e9861d0cf83e9100ad0d0369147db3ef4ea73.zip | |
Enable BEFORE row-level triggers for partitioned tables
... with the limitation that the tuple must remain in the same
partition.
Reviewed-by: Ashutosh Bapat
Discussion: https://postgr.es/m/20200227165158.GA2071@alvherre.pgsql
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_trigger.sgml | 2 | ||||
| -rw-r--r-- | doc/src/sgml/trigger.sgml | 3 |
2 files changed, 2 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml index 3b8f25ea4a5..bde3a63f90f 100644 --- a/doc/src/sgml/ref/create_trigger.sgml +++ b/doc/src/sgml/ref/create_trigger.sgml @@ -526,7 +526,7 @@ UPDATE OF <replaceable>column_name1</replaceable> [, <replaceable>column_name2</ Creating a row-level trigger on a partitioned table will cause identical triggers to be created in all its existing partitions; and any partitions created or attached later will contain an identical trigger, too. - Triggers on partitioned tables may only be <literal>AFTER</literal>. + Triggers on partitioned tables may not be <literal>INSTEAD OF</literal>. </para> <para> diff --git a/doc/src/sgml/trigger.sgml b/doc/src/sgml/trigger.sgml index 7d9ad4763aa..4a0e74652f7 100644 --- a/doc/src/sgml/trigger.sgml +++ b/doc/src/sgml/trigger.sgml @@ -116,8 +116,7 @@ operated on, while row-level <literal>AFTER</literal> triggers fire at the end of the statement (but before any statement-level <literal>AFTER</literal> triggers). These types of triggers may only be defined on tables and - foreign tables, not views; <literal>BEFORE</literal> row-level triggers may not - be defined on partitioned tables. + foreign tables, not views. <literal>INSTEAD OF</literal> triggers may only be defined on views, and only at row level; they fire immediately as each row in the view is identified as needing to be operated on. |