Re: Error in trigger after upgrading to 8.0.1? - Mailing list pgsql-general

From Tom Lane
Subject Re: Error in trigger after upgrading to 8.0.1?
Date
Msg-id 29947.1107643356@sss.pgh.pa.us
Whole thread Raw
In response to Error in trigger after upgrading to 8.0.1?  (Bjørn T Johansen <btj@havleik.no>)
List pgsql-general
=?ISO-8859-1?Q?Bj=F8rn_T_Johansen?= <btj@havleik.no> writes:
> 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?

Just what it says.  What are you doing declaring that trigger function
as immutable (or stable), when it has side effects?

            regards, tom lane

pgsql-general by date:

Previous
From: Sven Willenberger
Date:
Subject: Re: Error in trigger after upgrading to 8.0.1?
Next
From: Bjørn T Johansen
Date:
Subject: Re: Error in trigger after upgrading to 8.0.1?