[Fwd: [ADMIN] Transaction Aborting on sql call failure] - Mailing list pgsql-hackers

From Haroldo Stenger
Subject [Fwd: [ADMIN] Transaction Aborting on sql call failure]
Date
Msg-id 3BA38F2F.60894481@adinet.com.uy
Whole thread Raw
List pgsql-hackers
Sorry, I forgot to repost in hackers.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-hackers by date:

Previous
From: Chamanya
Date:
Subject: Re: Status of index location patch
Next
From: "Jim Buttafuoco"
Date:
Subject: Re: Status of index location patch