Re: Typo in trigger docs

2017-05-23 7:40 GMT-03:00 <igorludi(at)gmail(dot)com>:

>
> I believe that (&quot;statement&quot; is wrong):
>
> &quot;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).&quot;
>
>
> should be:
>
> &quot;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).&quot;

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>