Skip site navigation (1) Skip section navigation (2)

Re: Transaction Questions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rkut(at)intelerad(dot)com
Cc: pgsql-novice(at)postgresql(dot)org, Mathew Kanner <Mathew(dot)Kanner(at)intelerad(dot)com>
Subject: Re: Transaction Questions
Date: 2006-02-24 16:14:56
Message-ID: 3743.1140797696@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Richard Kut <rkut(at)intelerad(dot)com> writes:
> and that works as expected. However, if I get an error within the transaction 
> anywhere after the SAVEPOINT command, then the entire transaction fails, and 
> any changes made prior to the SAVEPOINT are rolled back.

Only because you deliberately told the system to roll back the entire
transaction.  You want to use ROLLBACK TO SAVEPOINT instead.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Richard KutDate: 2006-02-24 16:47:05
Subject: Re: Transaction Questions
Previous:From: Richard KutDate: 2006-02-24 14:57:06
Subject: Transaction Questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group