Re: [GENERAL] Question on STABLE functions limitations

2010-10-18 Thread Merlin Moncure
On Mon, Oct 18, 2010 at 4:47 AM, Marc Mamin 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 sho

Re: [GENERAL] Question on STABLE functions limitations

2010-10-18 Thread Tom Lane
"Marc Mamin" writes: > 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. set_config has side-effects and hence should not be done in non-volatile functions.

[GENERAL] Question on STABLE functions limitations

2010-10-18 Thread Marc Mamin
Hello, 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. Thanks in advance, Marc Mamin