Re: Question on STABLE functions limitations - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Question on STABLE functions limitations
Date
Msg-id AANLkTi=r2RH6S+Boqg0t9Mvqj66DBa3fpiwBXyx9BbOA@mail.gmail.com
Whole thread Raw
In response to Question on STABLE functions limitations  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-general
On Mon, Oct 18, 2010 at 4:47 AM, Marc Mamin <M.Mamin@intershop.de> wrote:
> I wonder if there are some special cases where STABLE functions should be
> avoided.
>
> I think for example of functions using set_config or querying the advisory
> locks.

Advisory locks are highly volatile and everything that touches them
should be considered volatile.  They are completely outside the mvcc
snapshot system and aren't bound by its rules (sequences also fall
under this category).

merlin

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question on STABLE functions limitations
Next
From: Torsten Zühlsdorff
Date:
Subject: Problem with initdb: creates database which do not exists