Subject | Re: [firebird-support] Re: *.FDB Lock Not Released when Process Shuts Down |
---|---|
Author | David Johnson |
Post date | 2005-07-20T12:18:01Z |
On Wed, 2005-07-20 at 08:56 +0000, flipmooooo wrote:
This is bad, verging on evil.
Construct a mechanism for the users to correct their problems, and
eliminate actual deletes from your design. Instead of deletes, flag
rows as invalid, then after a reasonable period of time, purge
invalidated rows.
> Users are getting paid for doing data entry on the db, one user mightSo an entire day's work is wiped out for a single data entry error?
> have done something wrong deleting/updating data that should not be
> updated/deleted, requests a DB restore to correct what he did ...
> Don't think its that rare.
This is bad, verging on evil.
Construct a mechanism for the users to correct their problems, and
eliminate actual deletes from your design. Instead of deletes, flag
rows as invalid, then after a reasonable period of time, purge
invalidated rows.