I use a "raise error" statement in a data base procedure that is called by rule and this rule is fired by another data base procedure.
Example :

dpb_1 = BEGIN
UPDATE table
SET colum = 1

END;

rule_1 (execute procedure dbp_2 after update (colum) on table );

dpb_2 = BEGIN

RAISE ERROR 19001 ' Error message';

END;

I want to know the value of raise error ( 19001 ) in the first data base procedure.

Thanks, Sergio

"Sergio" <sergio.sperandio66 (AT) tin (DOT) it> wrote


You can't. The documented behaviour is that then a rule fired procedure
gets an error it immediately loses control and the statement that caused the
rule to execute the procedure also gets rolled back.

Roy