On Mon, Oct 18, 2010 at 4:47 AM, Marc Mamin <M.Mamin@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
