On Fri, Oct 3, 2008 at 7:41 AM, Jaime Casanova <[EMAIL PROTECTED] > wrote:
> On Thu, Oct 2, 2008 at 8:44 PM, Alvaro Herrera > <[EMAIL PROTECTED]> 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. -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com Mail sent from my BlackLaptop device
