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.