Displaying 1 result from an estimated 1 matches for "date_delet".
Did you mean:
date_deleted
2006 May 18
5
Overriding default DELETE behavior with logical deletes
...d customer service
tracking purposes.
In the past, I''ve implemented logical deletes as follows:
1. Oracle implementation:
Each table that must implement logical deletes has a view, eg:
USERS_RAW => real table, has columns:
is_deleted(boolean,default false)
date_deleted(timestamp, default null)
USERS => is a view on USERS_RAW (where isdeleted = false)
Oracle allows updating such a view without any extra triggers, so from
RoR point of view this is completely transparent.
PostgreSQL allows updating views, but with extra triggers, which is ugly
and not...