Received: from kss.net.au ([203.41.122.41]) by hub.org (8.10.1/8.10.1) with ESMTP id e6EE8G079835 for ; Fri, 14 Jul 2000 10:08:16 -0400 (EDT) Received: from kss.net.au (coco [10.10.1.9]) by kss.net.au (8.8.7/8.8.7) with ESMTP id AAA28287 for ; Sat, 15 Jul 2000 00:10:46 +1000 Message-ID: <396F1FAA.29F680B2@kss.net.au> Date: Sat, 15 Jul 2000 00:11:54 +1000 From: Carolyn Lu Wong X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: Trigger Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/149 I'm using V6.5.3. I'm trying to create transaction logs for particular table, so I need to write trigger on insert/delete/update on each row. Are there any examples/documents that can help me with this? In the "Interaction with the Trigger Manager" from the online document, it states that it's for V7.1 or later. Because I'm working on earlier version, do I need to modify my code if the database is upgraded to later versions? I'm writing the C program in under my home directory. How can I set up the environment so that my program compiles? Thanks in advance for any helps and directions.