Re: psql help

The convention here is to in-line replies, or bottom-post. Top-posting
makes the archives more difficult to read.

On Thursday, July 4, 2024, Murthy Nunna <mnunna(at)fnal(dot)gov> wrote:

> pg_terminate_backend(pid) will not work as it expects only one pid at a
> time.
>
>
> Interesting…I wouldn’t expect the function calls to interact that
way…maybe try putting the select query into a plpgsql DO command loop and
then call pg_terminate_backend once per loop iteration.

> So, the question is how to rewrite this psql so it loops through all pids
> one pid at a time?
>
> I can’t tell if you really mean the psql program or are misusing the term
to mean something different…the code you wrote doesn’t seem like it would
execute in psql.

David J.