Hi tamil,

HTML Code:
Xeneize:

In postgres i can do this with a trigger on delete, set the flag on YES and then interrup the delete.
The row does not need to deleted, set the column deleted to be 'YES' when ever a delete command is run.