Re: Truncate Triggers

[Gregory Stark <stark(at)enterprisedb(dot)com>]

"Decibel!" <decibel(at)decibel(dot)org> writes:

> CLUSTER isn't DDL. Most forms of ALTER TABLE are. And CREATE blah, etc.

Fwiw I would call CLUSTER DDL. Note that it does make a change that's visible
in the table definition afterwards.

There are plenty of DDL commands which modify data (CREATE INDEX, ATLER TABLE
ALTER COLUMN TYPE). The defining characteristic of DDL is not that it doesn't
modify the data but that it does modify the table definition.

By that definition CLUSTER is DDL and TRUNCATE is DDL if you look at the
implementation rather than the user-visible effects.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's RemoteDBA services!