Обсуждение: [DOCS] Typo in trigger docs
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/trigger-definition.html Description: https://www.postgresql.org/docs/9.6/static/trigger-definition.html I believe that ("statement" is wrong): "Row-level BEFORE triggers fire immediately before a particular row is operated on, while row-level AFTER triggers fire at the end of the statement (but before any statement-level AFTER triggers)." should be: "Row-level BEFORE triggers fire immediately before a particular row is operated on, while row-level AFTER triggers fire after the row has been operated on (but before any statement-level AFTER triggers)." BR, Igor
2017-05-23 7:40 GMT-03:00 <igorludi@gmail.com>:
I believe that ("statement" is wrong):
"Row-level BEFORE triggers fire immediately before a particular row is
operated on, while row-level AFTER triggers fire at the end of the statement
(but before any statement-level AFTER triggers)."
should be:
"Row-level BEFORE triggers fire immediately before a particular row is
operated on, while row-level AFTER triggers fire after the row has been
operated on (but before any statement-level AFTER triggers)."
The documentation is correct. Execute the attached script to understand how trigger visibility works. AFTER row-level triggers will see all data changes [1].
[1] https://www.postgresql.org/docs/9.6/static/trigger-datachanges.html
--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento