Re: rollback

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Adrian Moisey" <adrian(at)careerjunction(dot)co(dot)za>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: rollback
Date: 2008-07-09 13:56:01
Message-ID: 396486430807090656x60a8d69dyb75dfb6e048394db@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 9, 2008 at 6:38 AM, Adrian Moisey
<adrian(at)careerjunction(dot)co(dot)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

In response to

  • rollback at 2008-07-09 13:38:52 from Adrian Moisey

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-07-09 13:56:08 Re: rollback
Previous Message A. Kretschmer 2008-07-09 13:55:33 Re: rollback