Table History
| От | Richard Sydney-Smith |
|---|---|
| Тема | Table History |
| Дата | |
| Msg-id | 002101c4e400$f0164220$13dd8a90@athlon2000 обсуждение исходный текст |
| Ответы |
Re: Table History
|
| Список | 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
В списке pgsql-sql по дате отправления: