Re: rollback - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: rollback
Date
Msg-id 20080709135608.GD18930@svana.org
Whole thread Raw
In response to rollback  (Adrian Moisey <adrian@careerjunction.co.za>)
Responses Re: rollback
List pgsql-general
On Wed, Jul 09, 2008 at 03:38:52PM +0200, Adrian Moisey wrote:
> Hi
>
> I would like to be able to "mark" a point in my postgres database.
> After that I want to change a few things and "rollback" to that point.
> Does postgres support such a thing?  Is it possible for me to do this?

Well, transactions do that. If you want to do this inside a
transaction, the term you're looking for is "savepoints".

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Attachment

pgsql-general by date:

Previous
From: "Richard Broersma"
Date:
Subject: Re: rollback
Next
From: Adrian Moisey
Date:
Subject: Re: rollback