Re: Versioning control in PostgreSQL?

From: elein <elein(at)varlena(dot)com>
To: Alex Page <alex(dot)page(at)cancer(dot)org(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Versioning control in PostgreSQL?
Date: 2003-11-01 21:22:46
Message-ID: 20031101132246.A10511@cookie.varlena.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)varlena(dot)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(dot)page(at)cancer(dot)org(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lynn.Tilby 2003-11-01 23:23:49 Re: 7.3.5 release (was: Re: SELECT with row>32k hangs over
Previous Message George Essig 2003-11-01 18:38:43 Re: [SQL] connectby