Re: why VOLATILE attribute is required?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: why VOLATILE attribute is required?
Date: 2011-09-22 14:05:38
Message-ID: 17877.1316700338@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-09-22 14:12:03 Re: [GENERAL] Date time value error in Ms Access using pass through queries
Previous Message Albe Laurenz 2011-09-22 12:53:28 Re: Problem dbi_link with postgresql 9.04