"Marcelo Costa" <marcelojscosta@xxxxxxxxx> 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
