Re: BUG #15003: pg_terminate_backend does not work

On Thu, 11 Jan 2018 08:43:27 +0000
PG Bug reporting form <noreply@postgresql.org> wrote:

> pg_terminate_backend returns true, but it does not terminates backend.
>
> query - "select sync_devices_run()"

Does the function sync_devices_run() do any sort of IO other than database
queries? pg_terminate_backend() can only terminate queries that are running
postgresql code, so if the function is making a blocking system call for
example, network IO pg_terminate_backend() can't do anything.


-dg

-- 
David Gould                                   daveg@sonic.net
If simplicity worked, the world would be overrun with insects.