| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Marcelo Costa" <marcelojscosta(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Function ERRO after UPGRADE from 7.4 to 8.1.5 |
| Date: | 2006-11-24 19:05:33 |
| Message-ID: | 8815.1164395133@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Marcelo Costa" <marcelojscosta(at)gmail(dot)com> writes:
> I migrate my database from 7.4 to 8.1.5 and make tests with aplication
> but this dont works fine.
> Some trigers dont 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2006-11-24 19:05:48 | Re: Function ERRO after UPGRADE from 7.4 to 8.1.5 |
| Previous Message | Marcelo Costa | 2006-11-24 17:45:10 | Function ERRO after UPGRADE from 7.4 to 8.1.5 |