Re: Error abort transaction behaviour - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Error abort transaction behaviour
Date
Msg-id 200207232155.g6NLtfo06342@candle.pha.pa.us
Whole thread Raw
In response to Re: Error abort transaction behaviour  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> hyldgaard@hotmail.com (Thomas Hyldgaard) writes:
> > As I can read from other appends then the behaviour where transactions
> > are aborted if errors occur is "working as designed" in PostgreSQL.
> > I'm using PostgreSQL 7.2. Is this something that will be changed in a
> > later version of PostgreSQL?
>
> Maybe someday, but it's not just around the corner.

Yes, nested transactions/savepoints is what we need.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: column limit?
Next
From: Bruce Momjian
Date:
Subject: Re: Multi-Versions and Vacuum -- cf Oracle & Vacuum alt