Re: Transaction Aborting on sql call failure - Mailing list pgsql-admin

From Haroldo Stenger
Subject Re: Transaction Aborting on sql call failure
Date
Msg-id 3BA38E83.25A1EC09@adinet.com.uy
Whole thread Raw
In response to Re: Transaction Aborting on sql call failure  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Transaction Aborting on sql call failure  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Stephan Szabo wrote:
>
> > We are running into a situation where psql is aborting the transaction
> > when one call returns an error.  Is there a way to continue on with
> > transaction or at least save what has already happened (like an Oracle
> > Save Point)?
>
> Not yet, although savepoints have been talked about. (maybe 7.3?)

New SMGR opens the way to this *very important* feature. Vadim?

Another proposal to solve this was recently proposed, not using WAL. Bruce?

I think this issue is rasing in the lists frequently enough, as for giving it
top priority. Maybe is isn't so easy. Comments?

Thanks

Regards,
Haroldo.

pgsql-admin by date:

Previous
From: GB Clark II
Date:
Subject: Re: Can't get postmaster to restart after removing WAL files
Next
From: Bruce Momjian
Date:
Subject: Re: Transaction Aborting on sql call failure