SQL error - Mailing list pgsql-general

From x asasaxax
Subject SQL error
Date
Msg-id 91495cb0804190747l3e29c7e8i169c90a44c27d12e@mail.gmail.com
Whole thread Raw
Responses Re: SQL error  (Martijn van Oosterhout <kleptog@svana.org>)
Re: SQL error  (Craig Ringer <craig@postnewspapers.com.au>)
Re: SQL error  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
HI everyone,


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:
BEGIN
  insert into temp values(1, 2, 3);
  IF ANY_ERROR_OCCURED THEN
     ROLLBACK;
     RETURN FALSE;
  END IF;
END;

Did anyone knows how can i do that?

Thanks a lot!

pgsql-general by date:

Previous
From: "Richard Broersma"
Date:
Subject: Re: very slow updates in 8.3?
Next
From: Craig Ringer
Date:
Subject: Initial ugly reverse-translator