On Mon, Oct 18, 2010 at 4:47 AM, Marc Mamin <M(dot)Mamin(at)intershop(dot)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