Re: How do I save data and then raise an exception?

On Fri, Oct 3, 2008 at 7:41 AM, Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec
> wrote:

> On Thu, Oct 2, 2008 at 8:44 PM, Alvaro Herrera
> <alvherre(at)commandprompt(dot)com> wrote:
> > Rob Richardson wrote:
> >
> >> Here's what I need to do:
> >>
> >> IF query_check_fails THEN
> >> UPDATE some_table SET some_value = 0 WHERE some_condition_is_true;
> >> RAISE EXCEPTION 'Look, you idiot, do it right next time!';
> >> END;
> >>
> >> I need the update to work, but I need to raise the exception so the C++
> >> code recognizes the error. How can I do both?
> >
> > You need an autonomous transaction, which Postgres does not support
> > directly but you can implement using dblink or a plperl function that
> > connects back to the database.
> >
>
> what about RAISE NOTICE?

NOTICE wouldn't rollback any part of the transaction! OP needs mixed COMMIT
success in the same transaction.

--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device