Re: History-based (or logged) database. - Mailing list pgsql-general

From Chris Travers
Subject Re: History-based (or logged) database.
Date
Msg-id 00af01c3d910$1b3220c0$71285e3d@winxp
Whole thread Raw
In response to History-based (or logged) database.  ("Octavio Alvarez" <alvarezp@alvarezp.ods.org>)
Responses Re: History-based (or logged) database.
List pgsql-general
Hi Elein;

Nope, OLD is correct.  I track the OLD values and then use the view to
combine those with the current ones.  This allows the OLAP portions of the
code to hit against *all* the data, while archiving old, outdated
information in the archive table.  It also allows deleted tuples to be
tracked with the same trigger since a deleted row doesn't exactly have a NEW
tuple :-) Maybe you misunderstand what I am trying to do?

Best WIshes,
Chris Travers


pgsql-general by date:

Previous
From: Sai Hertz And Control Systems
Date:
Subject: Re: insertion with trigger failed unexpectedly
Next
From: David Garamond
Date:
Subject: Re: Drawbacks of using BYTEA for PK?