Thread: blocking function in PL/Python

blocking function in PL/Python

From
Ottavio Campana
Date:
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?


Attachment

Re: blocking function in PL/Python

From
Richard Huxton
Date:
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