postgres.git / summary / log / commit / refs

commit    5292570ba19ec3f8281ef0e4233cb5cad3d30a47
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Thu Nov 07 20:49:59 2019 +0000
First released in: 13.0, 9.4.25, 9.5.20, 9.6.16, 10.11, 11.6, 12.2

    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


doc/src/sgml/trigger.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/doc/src/sgml/trigger.sgml b/doc/src/sgml/trigger.sgml index b5d506abcec..06297895e9c 100644 --- a/doc/src/sgml/trigger.sgml +++ b/doc/src/sgml/trigger.sgml @@ -207,7 +207,7 @@ used to signal that the trigger performed the necessary data modifications in the view. This will cause the count of the number of rows affected by the command to be incremented. For - <command>INSERT</> and <command>UPDATE</> operations, the trigger + <command>INSERT</> and <command>UPDATE</> operations only, the trigger may modify the <varname>NEW</> row before returning it. This will change the data returned by <command>INSERT RETURNING</> or <command>UPDATE RETURNING</>, [parent: 831ca9513c59]