Re: SQL error - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: SQL error
Date
Msg-id 20080419150723.GC32096@svana.org
Whole thread Raw
In response to SQL error  ("x asasaxax" <xanaruto@gmail.com>)
List pgsql-general
On Sat, Apr 19, 2008 at 11:47:19AM -0300, x asasaxax wrote:
> I´m trying to capture all the possible errors that a statement can have.
> And, if there´s any error i will do a rollback; What i´m trying to do its:

What are you trying to do? Any error automatically rolls back the
transaction, so:

> BEGIN
>   insert into temp values(1, 2, 3);
> END;

Should do what you want.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Attachment

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: very slow updates in 8.3?
Next
From: Craig Ringer
Date:
Subject: Re: SQL error