From: | Daniel Baldoni <pgsql(at)lcds(dot)com(dot)au> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Triggers on TRUNCATE? |
Date: | 2004-07-26 08:27:08 |
Message-ID: | 4104C05C.D7BDFA54@lcds.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-07-26 08:34:48 | Re: group by query? |
Previous Message | Suresh Tri | 2004-07-26 08:18:51 | Re: Improvements to PostgreSQL |