Received: from trillium.nmsu.edu (trillium.NMSU.Edu [128.123.5.15]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA80403 for ; Tue, 15 Jun 1999 15:12:02 -0400 (EDT) (envelope-from brook@trillium.NMSU.Edu) Received: (from brook@localhost) by trillium.nmsu.edu (8.8.8/8.8.8) id NAA28058; Tue, 15 Jun 1999 13:11:52 -0600 (MDT) Date: Tue, 15 Jun 1999 13:11:52 -0600 (MDT) Message-Id: <199906151911.NAA28058@trillium.nmsu.edu> X-Authentication-Warning: trillium.nmsu.edu: brook set sender to brook@trillium.nmsu.edu using -f From: Brook Milligan To: mo@local2me.com CC: pgsql-sql@postgreSQL.org In-reply-to: <3765E361.3570C6EA@local2me.com> (message from Michael Olivier on Tue, 15 Jun 1999 05:23:45 +0000) Subject: Re: [SQL] example of trigger to track DB changes References: <3765E361.3570C6EA@local2me.com> I've looked through the trigger examples in the html doc and the src tree but didn't find the one I was looking for. Look in the rules docs instead. I want to set up a trigger to track changes (add/update/delete) to rows in two tables. This can be through inserting OID's or acctname's (acctname of web users) into a "changed_rows" table that keeps track of changed rows. Would someone provide some source code that does this? I'm assuming a lot of people have done this... I'm using 6.3.2 ... The rules docs describe how to do exactly this and give an example. Cheers, Brook