Postgres Pro
Downloads
Home   >   mailing lists

Thread: [DOCS] Typo in trigger docs

[DOCS] Typo in trigger docs

From
igorludi@gmail.com
Date:
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

Re: [DOCS] Typo in trigger docs

From
Euler Taveira
Date:
2017-05-23 7:40 GMT-03:00 <igorludi@gmail.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
Attachment