postgres version control? - Mailing list pgsql-hackers

From Amit Kulkarni
Subject postgres version control?
Date
Msg-id 43A1E8AD.2050706@lsu.edu
Whole thread Raw
Responses Re: postgres version control?  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
Hi all,

Quite new to Postgres and initially driven here due to PostGIS. One 
thing I was looking at was the ability to roll back to a certain time, 
multiple editing, and QC. Basically a version control for databases. I 
went through the TODO list and I don't see this listed there, unless it 
is in the context of Point-in-time-recovery.

I asked my brother for help, and he sent me a link to Martin Fowler's
temporal site http://www.martinfowler.com/ap2/timeNarrative.html

(We discussed maintaining a master table, and recording all SQL DMLs, 
basically a-rolling-your-own implementation.)

Fowler refers to Snodgrass 99, and I am waiting to get hold of 
Snodgrass. Then today I came to know of Oracle Workspace Manager.

This product is used by Intergraph in their Geomedia Transaction 
Manager, which relies totally on OWM to manage conflicts of multiple 
edits in the same geographic area. I suspect that some other Geographic 
vendors are also using OWM (Ionic RedSpider) though I am not sure. I 
didn't post to the PostGIS list as I am thinking the question properly 
belongs here.

Is anything like this in the works either here or in Bizgres?

Thanks in advance!


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: 7.3 failure on platypus
Next
From: "Jim C. Nasby"
Date:
Subject: Re: postgres version control?