How to keep a record in the database, however, hidden to the system?

Asked

Viewed 74 times

2

I have an application in Delphi and need that in this application when the user deletes a record, this record continues in the database, but is hidden in the system.

postgresql

1 answer

7

You can apply what is known as logical deletion: In the application exclusion procedure execute the command UPDATE instead of DELETE, by changing the value of the "excluded" column to true. In listing records, consider only those that have the value of the 'deleted' column with the values NULL and false.

  • 6

    Also known as Soft-delete.

Browser other questions tagged postgresql

You are not signed in. Login or sign up in order to post.