| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Haroldo Stenger <hstenger(at)adinet(dot)com(dot)uy> |
| Cc: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, Michael Baker <mike(at)scmlabs(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Transaction Aborting on sql call failure |
| Date: | 2001-09-15 19:04:31 |
| Message-ID: | 200109151904.f8FJ4VX04195@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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?
Yes, see TODO page under transactions. It has my email about it.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Eriko Barreto Brito | 2001-09-17 20:23:47 | Left Joins |
| Previous Message | Haroldo Stenger | 2001-09-15 17:23:15 | Re: Transaction Aborting on sql call failure |