Re: disable auto-commit - Mailing list pgsql-admin

From John McKown
Subject Re: disable auto-commit
Date
Msg-id Pine.LNX.4.21.0010261427110.17136-100000@linux2.johnmckown.net
Whole thread Raw
In response to disable auto-commit  ("Joel Pang" <joelpang@spectratech.com>)
List pgsql-admin
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?
>


pgsql-admin by date:

Previous
From: Ian Lance Taylor
Date:
Subject: Building in a different directory
Next
From: "Sivagami ."
Date:
Subject: Create Procedure syntax