Skip to content

Commit 87477b6

Browse files
committed
docs: clarify that only INSERT and UPDATE triggers can mod. NEW
The point is that DELETE triggers cannot modify any values. Reported-by: Eugen Konkov Discussion: https://postgr.es/m/919823407.20191029175436@yandex.ru Backpatch-through: 9.4
1 parent b20233a commit 87477b6

File tree

1 file changed

+1
-1
lines changed

1 file changed

+1
-1
lines changed

doc/src/sgml/trigger.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -172,7 +172,7 @@
172172
used to signal that the trigger performed the necessary data
173173
modifications in the view. This will cause the count of the number
174174
of rows affected by the command to be incremented. For
175-
<command>INSERT</> and <command>UPDATE</> operations, the trigger
175+
<command>INSERT</> and <command>UPDATE</> operations only, the trigger
176176
may modify the <varname>NEW</> row before returning it. This will
177177
change the data returned by
178178
<command>INSERT RETURNING</> or <command>UPDATE RETURNING</>,

0 commit comments

Comments
 (0)