2017-05-23 7:40 GMT-03:00 <igorl...@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 <http://www.timbira.com.br>
a.sql
Description: application/sql
-- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs