Re: Error in trigger after upgrading to 8.0.1?

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