Re: why VOLATILE attribute is required? - Mailing list pgsql-general

From Albe Laurenz
Subject Re: why VOLATILE attribute is required?
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2049FCE75@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Is 9.1 considered more stable/robust than 9.0.4 ?  ("Abraham, Danny" <danny_abraham@bmc.com>)
List pgsql-general
Rafal Pietrak wrote:
> ERROR:  ALTER ROLE is not allowed in a non-volatile function
>
> Why???

See http://www.postgresql.org/docs/8.3/static/xfunc-volatility.html :

A STABLE function cannot modify the database [...]

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Rafal Pietrak
Date:
Subject: Re: why VOLATILE attribute is required?
Next
From: "Albe Laurenz"
Date:
Subject: Re: limitby without orderby