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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
