Re: Should TRUNCATE fire DDL triggers

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Should TRUNCATE fire DDL triggers
Дата
Msg-id CAKFQuwYH4ndD3jJvaHEqE6apSD=nS+TumopF1a8VoaFCmZDJWg@mail.gmail.com
обсуждение исходный текст
Ответ на Should TRUNCATE fire DDL triggers  (Hari Krishna Sunder <hari.db.pg@gmail.com>)
Ответы Re: Should TRUNCATE fire DDL triggers
Список pgsql-hackers
Дерево обсуждения
On Tuesday, July 8, 2025, Hari Krishna Sunder <hari.db.pg@gmail.com> wrote:
First of all, is TRUNCATE a DDL or a DML? This doc refers to it as a DDL, whereas other docs like this and this 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.

В списке pgsql-hackers по дате отправления: