Re: SQL Rule

["Bert" <clemens(dot)bertschler(at)gmail(dot)com>]

Okay sorry i have to change the trigger from AFTER TO BEFORE
CREATE TRIGGER trigger_sum
        BEFORE INSERT OR UPDATE
        ON test
        FOR EACH ROW
        EXECUTE PROCEDURE trigger_test();

TO ALBAN
Our table definition are the same, so what? A primary key is a
constraint.
And
>> CREATE OR REPLACE RULE sum_op AS
>>     ON INSERT TO test DO  UPDATE test SET c = new.a + new.b
>>   WHERE test.id = new.id;

>How do you expect to update a record that doesn't exist yet?
This rule is creating first of all the insert and then i can run an
Update on this insert, so far its functioning. Your definition is quite
good but what are doing when you change the table definition? Rewrite
all Rules?
But nevertheless thank you.
Best regards,
Bert