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 [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> > 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
