Re: Should TRUNCATE fire DDL triggers

On Tuesday, July 8, 2025, Hari Krishna Sunder <hari(dot)db(dot)pg(at)gmail(dot)com> wrote:

> First of all, is TRUNCATE a DDL or a DML? This
> <https://www.postgresql.org/docs/current/mvcc-caveats.html> doc refers to
> it as a DDL, whereas other docs like this
> <https://www.postgresql.org/docs/17/runtime-config-logging.html#GUC-LOG-STATEMENT>
> and this
> <https://www.postgresql.org/docs/17/hot-standby.html#HOT-STANDBY-USERS> treat
> it as a DML, so which one is it?
>

Neither…classification systems are often imperfect…but it sure quacks like
DML to my ears. I’d probably remove the term “DDL” from that first link
and avoid the grey area. Listing the two commands suffices.

>
> A lot of other SQL databases treat TRUNCATE as a DDL, so assuming that is
> true, can we add it to the command tags supported by "ddl_command_start"
> and "ddl_command_end" triggers?
>
>
Seems worthy of consideration regardless of how one answers the prior
question; for much the same reason.

David J.