Content-Length: 265670 | pFad | http://github.com/postgrespro/postgres_cluster/commit/3acfe6b089a5283c2961eb2ff135106e23b89263

A6 Fix docs regarding AFTER triggers on partitioned tables · postgrespro/postgres_cluster@3acfe6b · GitHub
Skip to content

Commit 3acfe6b

Browse files
committed
Fix docs regarding AFTER triggers on partitioned tables
In commit 86f5759 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
1 parent 2d8a6fa commit 3acfe6b

File tree

1 file changed

+4
-2
lines changed

1 file changed

+4
-2
lines changed

doc/src/sgml/trigger.sgml

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -115,8 +115,10 @@
115115
<literal>BEFORE</literal> triggers fire immediately before a particular row is
116116
operated on, while row-level <literal>AFTER</literal> triggers fire at the end of
117117
the statement (but before any statement-level <literal>AFTER</literal> triggers).
118-
These types of triggers may only be defined on non-partitioned tables and
119-
foreign tables, not views. <literal>INSTEAD OF</literal> triggers may only be
118+
These types of triggers may only be defined on tables and
119+
foreign tables, not views; <literal>BEFORE</literal> row-level triggers may not
120+
be defined on partitioned tables.
121+
<literal>INSTEAD OF</literal> triggers may only be
120122
defined on views, and only at row level; they fire immediately as each
121123
row in the view is identified as needing to be operated on.
122124
</para>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres_cluster/commit/3acfe6b089a5283c2961eb2ff135106e23b89263

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy