Skip site navigation (1) Skip section navigation (2)

Table History

From: "Richard Sydney-Smith" <richard(at)ibisaustralia(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Table History
Date: 2004-12-17 06:23:32
Message-ID: 002101c4e400$f0164220$13dd8a90@athlon2000 (view raw or flat)
Thread:
Lists: pgsql-sql
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
 

Responses

pgsql-sql by date

Next:From: Michael FuhrDate: 2004-12-17 06:52:09
Subject: Re: FUNCTION, TRIGGER and best practices
Previous:From: Josh BerkusDate: 2004-12-17 05:43:32
Subject: Re: FUNCTION, TRIGGER and best practices

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group