Commit3acfe6b

committed

Fix docs regarding AFTER triggers on partitioned tables

In commit86f5759 I forgot to update the trigger.sgml paragraphthat needs to explain that AFTER triggers are allowed in partitionedtables. Do so now.Discussion:https://postgr.es/m/20200224185850.GA30899@alvherre.pgsql

1 parent2d8a6fa commit3acfe6bCopy full SHA for 3acfe6b

File tree

-2

lines changed

-2

lines changed

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -115,8 +115,10 @@`
`115`	`115`	`<literal>BEFORE</literal> triggers fire immediately before a particular row is`
`116`	`116`	`operated on, while row-level <literal>AFTER</literal> triggers fire at the end of`
`117`	`117`	`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`
`120`	`122`	`defined on views, and only at row level; they fire immediately as each`
`121`	`123`	`row in the view is identified as needing to be operated on.`
`122`	`124`	`</para>`

Comments

(0)