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
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 |