Re: psql help
От
David G. Johnston
Тема
Re: psql help
Дата
Msg-id
CAKFQuwaEb004d7ODhPbFZ+uz724=85pGjR7TNNGGpSoiH1Cb0Q@mail.gmail.com
Ответ на
RE: psql help (Murthy Nunna)
Список
Дерево обсуждения
psql help Murthy Nunna <mnunna@fnal.gov>
Re: psql help "David G. Johnston" <david.g.johnston@gmail.com>
RE: psql help Murthy Nunna <mnunna@fnal.gov>
Re: psql help Adrian Klaver <adrian.klaver@aklaver.com>
Re: psql help "David G. Johnston" <david.g.johnston@gmail.com>
Re: psql help Tom Lane <tgl@sss.pgh.pa.us>
Re: psql help hubert depesz lubaczewski <depesz@depesz.com>
RE: psql help Murthy Nunna <mnunna@fnal.gov>
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 по дате отправления
