diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-02-26 19:57:14 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-02-26 19:57:14 -0300 |
| commit | 143152439dc9482b1ae983f2819453e7300eca7f (patch) | |
| tree | 4991ffffcdf5d10dbe2d31634bdc2921539957f4 | |
| parent | da2a7180aa0ed18d4e283a934d3f789912fd99c5 (diff) | |
| download | postgresql-143152439dc9482b1ae983f2819453e7300eca7f.tar.gz postgresql-143152439dc9482b1ae983f2819453e7300eca7f.zip | |
Fix docs regarding AFTER triggers on partitioned tables
In commit 86f575948c77 I forgot to update the trigger.sgml paragraph
that needs to explain that AFTER triggers are allowed in partitioned
tables. Do so now.
Discussion: https://postgr.es/m/20200224185850.GA30899@alvherre.pgsql
| -rw-r--r-- | doc/src/sgml/trigger.sgml | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/doc/src/sgml/trigger.sgml b/doc/src/sgml/trigger.sgml index f372f0ab8e9..900f8a9b565 100644 --- a/doc/src/sgml/trigger.sgml +++ b/doc/src/sgml/trigger.sgml @@ -115,8 +115,10 @@ <literal>BEFORE</literal> triggers fire immediately before a particular row is 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 non-partitioned tables and - foreign tables, not views. <literal>INSTEAD OF</literal> triggers may only be + 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. + <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. </para> |