"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