"Marcelo Costa" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
