On Thu, Oct 2, 2008 at 8:44 PM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> 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? -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157
