Also, I think we should patch the documentation like this, because this
effect is not 100% obvious. (For example, if the partition strategy is
identical in both referenced and referencing tables, you would wish that
only the equivalent partition is truncated. However, I doubt this can
be really implemented.)
I do wonder how do other RDBMSs behave.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services