Re: psql help
От | David G. Johnston |
---|---|
Тема | Re: psql help |
Дата | |
Msg-id | CAKFQuwaEb004d7ODhPbFZ+uz724=85pGjR7TNNGGpSoiH1Cb0Q@mail.gmail.com обсуждение исходный текст |
Ответ на | RE: psql help (Murthy Nunna <mnunna@fnal.gov>) |
Ответы |
Re: psql help
|
Список | pgsql-general |
The convention here is to in-line replies, or bottom-post. Top-posting makes the archives more difficult to read.
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.
В списке pgsql-general по дате отправления: