Re: Excuting SQL-Statements after error in same transaction ?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Michael Kleiser <mkl(at)webde-ag(dot)de>
Cc: "[NOVICE]" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Excuting SQL-Statements after error in same transaction ?
Date: 2004-06-18 15:06:15
Message-ID: 20040618150615.GA9388@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, Jun 18, 2004 at 12:28:25 +0200,
Michael Kleiser <mkl(at)webde-ag(dot)de> wrote:
>
> But one difference twould lead into much reprogramming:
> If there is an error in a transaction, I can't execute any further
> sql-statements in tge same transaction.
> I the existing code I have many expected errors like in this example:

Right now you can't. This will probably be possible in 7.5 as it looks
like there will be a nested transaction capability in 7.5. In about
two weeks there will be a more definite answer. Shortly after there should
be a 7.5 beta for you to play with. Look for 7.5 to be released sometime
this fall.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-06-18 15:17:35 Re: page x is unitialized
Previous Message Michael Kleiser 2004-06-18 10:28:25 Excuting SQL-Statements after error in same transaction ?