how to perform soft delete?

[PinkRose]

Hi all,
Can anyone help me, how to do soft delete?

[gimbal2]

Generally when you post a question consisting of one short line, it does not contain enough actual information and context. Try asking your question a tiny bit more elaborate.

[jashburn]

I know soft delete as to mark something for deletion, take it out of use, but is not yet actually deleted. In a database record context it's so that it is easy to recover from, e.g., accidental deletion. Is this what you meant by "soft delete"? You'll need to elaborate the context - soft delete what, purpose, etc., taking into account this is a Java programming forum.

[PinkRose]

i am trying simple crud operation using jsp/servlet. i want the values to be delete in jsp, when i perform delete operation. but the values wont be delete in database. i am using postgresql.

[PinkRose]

You are right jashburn

[gimbal2]

... So you have the problem of records not being deleted (A) and you then ask about a soft delete (B). If you want help with A, ask about A.

Why don't you just share the code that you have so we can see where your bug is.

[PinkRose]

Actually I have no idea about soft delete. I just need some guidance, how to perform soft delete operation.

[jashburn]

It seems that this is more of a design question rather than a coding question. For that, you'd want to go through The trouble with soft delete | Richard Dingwall to find out the approaches that might be suitable in your context.

Soft deletes can be done at the database itself. For PostgreSQL, see:

• https://coderwall.com/p/vezbtq
• coolkeums.org : Web developers, what can Postgresql do for you ?

or just google using the search term postgresql "soft delete" (include the double-quotes in the search term). My knowledge on the database side of things is quite limited, I'm afraid.

[PinkRose]

Thanks for your reply

[PinkRose]

Thanks for your links jashburn. i perform a soft delete operation. it works fine.