=?ISO-8859-1?Q?Bj=F8rn_T_Johansen?= <btj@xxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
