Обсуждение: blocking function in PL/Python

Поиск
Список
Период
Сортировка

blocking function in PL/Python

От
Ottavio Campana
Дата:
suppose we have a stored procedure written in PL/Python.

What happens if the function blocks for a while?

Does the server still works for the other clients?


Вложения

Re: blocking function in PL/Python

От
Richard Huxton
Дата:
Ottavio Campana wrote:
> suppose we have a stored procedure written in PL/Python.
>
> What happens if the function blocks for a while?
>
> Does the server still works for the other clients?

Yes. Each client has its own backend process.

Although, if you've taken locks that might block other clients.

--
   Richard Huxton
   Archonet Ltd