G'day folks, Forgive this if it's totally "out there" but I was wondering why there's no support for triggers on a TRUNCATE operation. I note that a COPY IN fires an INSERT trigger (if defined).
The only real use I can see for a TRUNCATE trigger would be for automatic audit trail generation - I usually have all operations on "core" tables audited. FYI, I'm using 7.4.3. As always, thanks for your time. Ciao. -- -------------------------------------------------------+--------------------- Daniel Baldoni BAppSc, PGradDipCompSci | Technical Director require 'std/disclaimer.pl' | LcdS Pty. Ltd. -------------------------------------------------------+ 856B Canning Hwy Phone/FAX: +61-8-9364-8171 | Applecross Mobile: 041-888-9794 | WA 6153 URL: http://www.lcds.com.au/ | Australia -------------------------------------------------------+--------------------- "Any time there's something so ridiculous that no rational systems programmer would even consider trying it, they send for me."; paraphrased from "King Of The Murgos" by David Eddings. (I'm not good, just crazy) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend