Re: Function ERRO after UPGRADE from 7.4 to 8.1.5 - Mailing list pgsql-admin

From Tom Lane
Subject Re: Function ERRO after UPGRADE from 7.4 to 8.1.5
Date
Msg-id 8815.1164395133@sss.pgh.pa.us
Whole thread Raw
In response to Function ERRO after UPGRADE from 7.4 to 8.1.5  ("Marcelo Costa" <marcelojscosta@gmail.com>)
List pgsql-admin
"Marcelo Costa" <marcelojscosta@gmail.com> writes:
> I migrate my database from 7.4 to 8.1.5 and make tests with aplication
> but this don�t works fine.

> Some trigers don�t work and send to me error messages as this:

> Warning: pg_query(): Query failed: ERROR: INSERT is not allowed in a
> non-volatile function

What do you find unclear about the error message?

It was never a sane idea to try to modify the database in a function
marked immutable or stable, because of the risk that the side-effects
would get optimized away.  8.1 enforces that, where older versions did
not.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Marcelo Costa"
Date:
Subject: Function ERRO after UPGRADE from 7.4 to 8.1.5
Next
From: Stephan Szabo
Date:
Subject: Re: Function ERRO after UPGRADE from 7.4 to 8.1.5