postgres.git / summary / log / commit / refs

commit    353647fd93c0ce871e6da3cc785220fcac17985e
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 be9c2284481..f372f0ab8e9 100644
--- a/doc/src/sgml/trigger.sgml
+++ b/doc/src/sgml/trigger.sgml
@@ -230,7 +230,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</command> and <command>UPDATE</command> operations, the trigger
+    <command>INSERT</command> and <command>UPDATE</command> operations only, the trigger
     may modify the <varname>NEW</varname> row before returning it.  This will
     change the data returned by
     <command>INSERT RETURNING</command> or <command>UPDATE RETURNING</command>,


[parent: 89f56fc223f9]