I’m trying to prevent any further input of a particular field value via an insert rule with the following rule.
CREATE OR REPLACE RULE rule_foovalue AS
ON INSERT TO foo
WHERE new.foovalue = 1 DO SELECT fooexception.fooexception
FROM fooexception() fooexception(fooexception);
Basically the stored procedure that it calls raises an exception. The behavior I wanted\excepted was to call the stored procedure when foovalue = 1 and to execute a regular insert when foovalue <> 1. What its doing is calling the stored procedure when foovalue = 1, that part works just fine. However, when I try to insert a record into foo with any other value besides 1 it actually inserts the record but doesn’t return the # of rows affected. Is there something else I need to add to the rule so that it returns the number of rows affected like normal?
Thanks,
Curtis
