| From: | Haroldo Stenger <hstenger(at)adinet(dot)com(dot)uy> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | 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 17:23:15 |
| Message-ID: | 3BA38E83.25A1EC09@adinet.com.uy |
| 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?
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-09-15 19:04:31 | Re: Transaction Aborting on sql call failure |
| Previous Message | GB Clark II | 2001-09-15 13:04:34 | Re: Can't get postmaster to restart after removing WAL files |