Re: Transactions, Triggers and Error Messages

Ledina Hido wrote:
>
> Thinking about it, the EXCEPTION statement would be inside my user-
> defined function (where I raise the exception in the first place), so I
> cannot see how that would help. As far as I could understand, I cannot
> call "ROLLBACK" (which is what I want to do) inside a user defined
> function. I tried calling it and it was simply ignored. Or am I missing
> something here?

Yes - you want to read up on SAVEPOINTs to handle exceptions at the
applicaton level. You do something like:

SAVEPOINT foo;
...command that works...
...command that works...
...oops, this one gives me an error...
ROLLBACK TO SAVEPOINT foo;

Exceptions in plpgsql are just a wrapper to this process.

--
Richard Huxton
Archonet Ltd