Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: why VOLATILE attribute is required?
Date
Msg-id 17877.1316700338@sss.pgh.pa.us
Whole thread Raw
In response to why VOLATILE attribute is required?  (Rafal Pietrak <rafal@zorro.isa-geek.com>)
List pgsql-general
Tree view 
Rafal Pietrak <rafal@zorro.isa-geek.com> writes:
> but I get:
> ERROR:  ALTER ROLE is not allowed in a non-volatile function
> Why???

Because non-volatile means, among other things, "this function has no
side effects".

            regards, tom lane

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Problem dbi_link with postgresql 9.04
Next
From: Adrian Klaver
Date:
Subject: Re: Date time value error in Ms Access using pass through queries