> 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.
I was also going to suggest that but did not, because autonomous transaction won't help here! The data has been INSERTed or UPDATEd in this transaction, and hence won't be visible to the autonomous transaction, because the main transaction hasn't committed yet.
