Jonathan Neve wrote:

>Any ideas about this?
>
>
>
>>So here it is. Why not create a sort of "undo-after-commit" feature,
>>whereby old versions of a record could be kept indefinitely, and if
>>necessary, restored of viewed?
>>
>>What might be good would be some sort of trace file, in
>>which, all obselete record versions are dumped, as and when they become
>>obselete. Then, there could be a simple API (or perhaps an SQL
>>extention) that could be used for loading old record versions back into
>>the DB, and also for purging out old versions periodically...
>>
>>
>>

This has come up about a dozen times over the years, often in the
context of rolling back to an earlier revision of a CAD project.
Everytime we've look at it in depth, we've come to the same conclusion,
which is that the application semantics need to be a great deal richer
than can be provided by a low level hack and vary signficantly from
application to application.

--

Jim Starkey
Netfrastructure, Inc.
978 526-1376