Re: rollback - Mailing list pgsql-general

From Richard Broersma
Subject Re: rollback
Date
Msg-id 396486430807090656x60a8d69dyb75dfb6e048394db@mail.gmail.com
Whole thread Raw
In response to rollback  (Adrian Moisey <adrian@careerjunction.co.za>)
List pgsql-general
On Wed, Jul 9, 2008 at 6:38 AM, Adrian Moisey
<adrian@careerjunction.co.za> wrote:
> 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?

Sure.  Check out savepoints.

http://www.postgresql.org/docs/8.3/interactive/sql-savepoint.html


--
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

pgsql-general by date:

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