"Decibel!" <[EMAIL PROTECTED]> 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! ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate