Re: Question on STABLE functions limitations

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Question on STABLE functions limitations
Дата
Msg-id AANLkTi=r2RH6S+Boqg0t9Mvqj66DBa3fpiwBXyx9BbOA@mail.gmail.com
обсуждение исходный текст
Ответ на Question on STABLE functions limitations  ("Marc Mamin" <M.Mamin@intershop.de>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Question on STABLE functions limitations
Следующее
От: Torsten Zühlsdorff
Дата:
Сообщение: Problem with initdb: creates database which do not exists