Re: rollback - Mailing list pgsql-general

From Adrian Moisey
Subject Re: rollback
Date
Msg-id 4874C424.1090903@careerjunction.co.za
Whole thread Raw
In response to Re: rollback  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: rollback
List pgsql-general
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".

I would like to do this globally over the entire DB, is that possible?

--
Adrian Moisey
Systems Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: rollback
Next
From: "A. Kretschmer"
Date:
Subject: Re: rollback