Re: How to undo changes / deletes ?

One way I use:

You can always create a datetime stamp on all your database tables to 
know when a record was created/updated/deleted.

If you have a status column to indicate Live/Archive or in some cases I 
use a value 0 = Live, 9 = Very old with each delete incrementing the 
status value with value + 1.  If value is 9 the record can be removed 
from the table.  Depending your User Permissions you are allowed to 
view/update archived records then.

Create triggers on your table:

DELETE TRIGGER that will trap the delete and only do a UPDATE on the 
Status column.

UPDATE TRIGGER trap the Update, INSERT a record in database with old 
values but with Status of "Archive", then do the update.

Only downside to this is that you need to do more work on keeping your 
relation****ps in place and a performance penalty in high volume 
transaction databases.

To rollback then is just a matter of deleting records created with a 
datetime stamp > supplied date and change status flag of last row found 
with datetime stamp < supplied date.

kunt wrote:
> Hi all,
> is there a way to undo changes in a database (e.g. those made because of

> a recent human error, an erroneous delete/update query)
> 
> For example reversing all transactions made in the last N days?
> 
> On any database? In particular I am most interested in postgres and 
> mysql... secondarily Oracle.
> 
> Thank you