| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | "Decibel!" <decibel(at)decibel(dot)org> |
| Cc: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Truncate Triggers |
| Date: | 2008-01-31 10:22:42 |
| Message-ID: | 87y7a6thu5.fsf@oxford.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2008-01-31 10:40:54 | Re: Truncate Triggers |
| Previous Message | Hannu Krosing | 2008-01-31 10:21:20 | Re: Will PostgreSQL get ported to CUDA? |