Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with FOUND - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Problem with FOUND
Date
Msg-id 162867790806271057hb731c27v87ab42cfa3caaafa@mail.gmail.com
Whole thread Raw
In response to Re: Problem with FOUND  ("A B" <gentosaker@gmail.com>)
List pgsql-general
Tree view 
2008/6/27 A B <gentosaker@gmail.com>:
> Thanks for the suggestion on GET DIAGNOSTICS.
>
> But concerning  EXECUTE, if I do
>
> BEGIN
>     EXECUTE QueryA
> EXCEPTION WHEN OTHERS THEN
>     QueryB
> END;
>
>
> will it execute QueryB if QueryA fails?

yes, but it's not preferable way. It creates subtransaction with some
(less) overhead.

Regards
Pavel
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: "Richard Broersma"
Date:
Subject: Re: IF ROW( NEW ) <> ROW( OLD )
Next
From: "Pavel Stehule"
Date:
Subject: Re: Nice to have: reverse() function in the core