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

From Bjørn T Johansen
Subject Error in trigger after upgrading to 8.0.1?
Date
Msg-id 42052C32.8010007@havleik.no
Whole thread Raw
Responses Re: Error in trigger after upgrading to 8.0.1?
Re: Error in trigger after upgrading to 8.0.1?
Re: Error in trigger after upgrading to 8.0.1?
List pgsql-general
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

--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj@havleik.no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Is there a peer-to-peer server solution with PG?
Next
From: "Reuben D. Budiardja"
Date:
Subject: Help with sorting (ie. ORDER BY expression)