Re: Error in trigger after upgrading to 8.0.1?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error in trigger after upgrading to 8.0.1?
Date: 2005-02-05 22:42:36
Message-ID: 29947.1107643356@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?ISO-8859-1?Q?Bj=F8rn_T_Johansen?= <btj(at)havleik(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bjørn T Johansen 2005-02-05 23:23:27 Re: Error in trigger after upgrading to 8.0.1?
Previous Message Sven Willenberger 2005-02-05 22:32:56 Re: Error in trigger after upgrading to 8.0.1?