Re: Moving to postgresql and some ignorant questions

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Thomas Kellerer" <spam_eater(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Moving to postgresql and some ignorant questions
Date: 2007-08-14 18:38:14
Message-ID: e373d31e0708141138w1efe1710p30bd221f469b0e8a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> You could do this with savepoints which are a kind of sub-transaction inside a
> "bigger" transaction.
>
> e.g.:
> BEGIN TRANSACTION;
>
> SAVEPOINT sp1;
> UPDATE1;
> IF (failed) rollback to savepoint sp1;
>
> SAVEPOINT sp1;
> UPDATE2;
> IF (failed) rollback to savepoint sp2;

Thanks Thomas, this is a great feature even if I am not looking for it
right now, I bet I can use it at some point!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-08-14 18:59:43 Re: MVCC cons
Previous Message Richard Huxton 2007-08-14 18:34:53 Re: Select time jump after adding filter; please help me figure out what I'm doing wrong.