Well, you could start a transaction. But the record will be deleted once
you do a COMMIT. Is that what you want? If you want some way to
"delete" an entry, but then to later "undelete" it, there really isn't a
way. I have heard of other systems where things were "logically deleted",
but recoverable until a "purge" command was done. PostgreSQL does not have
this type of behaviour.
John
On Wed, 25 Oct 2000, Joel Pang wrote:
> In psql, once I delete an entry, it's gone permanently. How do I disable
> such auto-commit behavior?
>