The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/trigger-definition.html
Description:

Hello,

documentation
(https://www.postgresql.org/account/comments/new/10/trigger-definition.html/)
says:

"A statement that targets a parent table in an inheritance or partitioning
hierarchy does not cause the statement-level triggers of affected child
tables to be fired; only the parent table's statement-level triggers are
fired."

However, I noticed that statement-level TRUNCATE triggers are fired both for
parent table and its partitions. Is the documentation inconsistent with the
actual PostgreSQL behaviour or I missed something? I made some tests and
checked PostgreSQL source code as well (ExecuteTruncate() function) and it
seems that there is some inconsistency.

Thank you.

Reply via email to