Bjørn T Johansen wrote:
I have just upgraded to 8.0.1 from 7.4.6 and now my triggers doesn't work. When I insert a row in a table that has an insert trigger, I get the following error msg:
ERROR: INSERT is not allowed in a non-volatile function
What does this mean?
Regards,
BTJ
It would appear as though the function in question was not created as a VOLATILE function (i.e. it was created with the STABLE or IMMUTABLE attribute).
Can you try and: CREATE OR REPLACE FUNCTION function_name ...... AS $$ <your function def> $$ LANGUAGE plpgsql VOLATILE;
Sven Willenberger
That did the trick, thx...
BTJ
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
