Received: from web20606.mail.yahoo.com (web20606.mail.yahoo.com [216.136.226.164]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAG2I2m72194 for ; Thu, 15 Nov 2001 21:18:02 -0500 (EST) (envelope-from mr_ocp@yahoo.com) Message-ID: <20011116021806.20613.qmail@web20606.mail.yahoo.com> Received: from [24.112.241.253] by web20606.mail.yahoo.com via HTTP; Fri, 16 Nov 2001 13:18:06 EST Date: Fri, 16 Nov 2001 13:18:06 +1100 (EST) From: =?iso-8859-1?q?Mr=20OCP?= Subject: Please help To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200111/89 X-Sequence-Number: 2614 Hi Can anyone help me write a trigger on a table, I have created an audit table for a table and what I want trigger to do is to whenever a record is deleted from the table it should first be inserted into the audit table, just to keep track of whatever records are deleted. Thanks so much for your time. Mike http://shopping.yahoo.com.au - Yahoo! Shopping - Get organised for Christmas early this year!