There is an example and discussion of implementing
history tracking of updates to a table. It includes
the discussion of the update rule technique as well.
See http://www.varlena.com/GeneralBits/38.php
elein
elein@varlena.com
On Tue, Oct 28, 2003 at 11:43:44AM +0000, Alex Page wrote:
> I haven't used PostgreSQL for nearly a year now, and when I was last
> using it there was some discussion on versioning control being
> introduced as a feature. Basically, for some data, I'd like to keep
> track of who changed it, when, and to what. I know I could include
> multiple values in the schema, and have a view to pull out the most
> recent, but I was wondering if there was something more automatic that
> is a feature of PostgreSQL itself. I've looked around the documentation
> with no success. Does anybody know if this is possible?
>
> Alex
> --
> Mail: Alex Page <alex.page@cancer.org.uk>
> Real: Systems/Network Assistant, Epidemiology Unit, Oxford
> Tel: 01865 302 223 (external) / 223 (internal)
> PGP: 8868 21D7 3D35 DD77 9D06 BF0A 0746 2DE6 55EA 367E