X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7E2D03CBE44 for ; Fri, 17 Dec 2004 06:20:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86426-10 for ; Fri, 17 Dec 2004 06:20:44 +0000 (GMT) Received: from gizmo01ps.bigpond.com (gizmo01ps.bigpond.com [144.140.71.11]) by svr1.postgresql.org (Postfix) with SMTP id C98613CBE3C for ; Fri, 17 Dec 2004 06:20:43 +0000 (GMT) Received: (qmail 3263 invoked from network); 17 Dec 2004 06:20:38 -0000 Received: from unknown (HELO PSMAM18.bigpond.com) (144.135.25.118) by gizmo01ps.bigpond.com with SMTP; 17 Dec 2004 06:20:38 -0000 Received: from pipp-p-144-134-197-42.prem.tmns.net.au ([144.134.197.42]) by PSMAM18.bigpond.com(MAM REL_3_4_2 297/12486474) with SMTP id 12486474; Fri, 17 Dec 2004 16:20:38 +1000 From: "Richard Sydney-Smith" To: Subject: Table History Date: Fri, 17 Dec 2004 14:23:32 +0800 Message-ID: <002101c4e400$f0164220$13dd8a90@athlon2000> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0022_01C4E443.FE398220" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.384 tagged_above=0 required=5 tests=HTML_60_70, HTML_MESSAGE, HTML_TEXT_AFTER_BODY, HTML_TEXT_AFTER_HTML X-Spam-Level: X-Archive-Number: 200412/113 X-Sequence-Number: 19733 This is a multi-part message in MIME format. ------=_NextPart_000_0022_01C4E443.FE398220 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit A database I maintain has a central transaction table ( FTRANS) I would like an second table FTRANS_IMAGE to maintain a historical view of ftrans. So if records in FTRANS are altered we can trace the effect of those changes in FTRANS_IMAGE. I expect this has been done MANY times and I wonder if a general purpose trigger exists or if not then can someone point me to an example set of triggers? I would like to trace an action code "Edit" or "Delete" in FTRANS_IMAGE in additional to the common fields. thanks muchly Richard Sydney-Smith --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004 ------=_NextPart_000_0022_01C4E443.FE398220 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Message
A = database I=20 maintain has a central transaction table ( FTRANS)
I = would like an=20 second table FTRANS_IMAGE to maintain a historical view of ftrans. So if = records=20 in FTRANS are altered we can trace the effect of those changes in=20 FTRANS_IMAGE.
 
I = expect this has=20 been done MANY times and I wonder if a general purpose trigger exists or = if not=20 then can someone point me to an example set of = triggers?
 
I = would like to=20 trace an action code "Edit" or "Delete" in FTRANS_IMAGE in additional to = the=20 common fields.
 
thanks = muchly
 
Richard=20 Sydney-Smith

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004

------=_NextPart_000_0022_01C4E443.FE398220--