On Feb 2, 2008 2:43 PM, David Fetter <[EMAIL PROTECTED]> wrote: > It still involves DDL-like operations in the sense of changing (for > the duration of the query) trigger behavior.
But that "change of trigger behavior" is still more in the "DML" sense than "DDL sense." The point of TRUNCATE is that we have an optimization that's superior (in some important senses) to "DELETE FROM." The differences between TRUNCATE FOO and DELETE FROM FOO do not have to do with the one altering the schema for the table. The schema remains the same. I think it would be nice to be able to have more "trigger hooks" relating to DDL changes, but I also think that will represent some fundamentally more difficult problems being raised than is the case for a TRUNCATE trigger. -- http://linuxfinances.info/info/linuxdistributions.html "The definition of insanity is doing the same thing over and over and expecting different results." -- assortedly attributed to Albert Einstein, Benjamin Franklin, Rita Mae Brown, and Rudyard Kipling ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
