[GENERAL] strategies for keeping an audit trail of UPDATEs

2001-02-20 Thread Louis-David Mitterrand
Hello, In our app we must keep a trace of all changes (UPDATEs) done to an important_table, so that it's possible to get a snapshot of a given record at a given date. The implementation strategy we are thinking about: 1. create an important_table_archive which inherits from important_table, 2

Re: [GENERAL] strategies for keeping an audit trail of UPDATEs

2001-02-20 Thread Rod Taylor
7 PM Subject: [GENERAL] strategies for keeping an audit trail of UPDATEs > Hello, > > In our app we must keep a trace of all changes (UPDATEs) done to an > important_table, so that it's possible to get a snapshot of a given > record at a given date. > > The implementation