Re: Versioning control in PostgreSQL?

scott.marlowe <scott.marlowe@ihs.com>

From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Alex Page <alex.page@cancer.org.uk>
Cc: <pgsql-general@postgresql.org>
Date: 2003-10-28T16:40:37Z
Lists: pgsql-general
On Tue, 28 Oct 2003, 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?

There's a nice example code in contrib/spi that might help here.