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 programmerwould even consider trying it, they send
forme."; paraphrased from "King OfThe Murgos" by David Eddings. (I'm not good, just crazy)