MIME-Version: 1.0
In-Reply-To: <DM8PR09MB66770B55E691C9685E5B5F7BB8DF2@DM8PR09MB6677.namprd09.prod.outlook.com>
References: <DM8PR09MB6677C5B4FDBDFC0F82298DC7B8DE2@DM8PR09MB6677.namprd09.prod.outlook.com>
 <CAKFQuwaYLtg0W4He0VGfqSTKSj+69sSq_5esqBVTHwSrPfMLmw@mail.gmail.com> <DM8PR09MB66770B55E691C9685E5B5F7BB8DF2@DM8PR09MB6677.namprd09.prod.outlook.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 4 Jul 2024 22:19:35 -0700
Message-ID: <CAKFQuwaEb004d7ODhPbFZ+uz724=85pGjR7TNNGGpSoiH1Cb0Q@mail.gmail.com>
Subject: Re: psql help
To: Murthy Nunna <mnunna@fnal.gov>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000098c534061c79356b"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwaEb004d7ODhPbFZ%2Buz724%3D85pGjR7TNNGGpSoiH1Cb0Q%40mail.gmail.com>
Precedence: bulk

--00000000000098c534061c79356b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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@fnal.gov> wrote:

> pg_terminate_backend(pid) will not work as it expects only one pid at a
> time.
>
>
> Interesting=E2=80=A6I wouldn=E2=80=99t expect the function calls to inter=
act that
way=E2=80=A6maybe try putting the select query into a plpgsql DO command lo=
op 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=E2=80=99t tell if you really mean the psql program or are misusing =
the term
to mean something different=E2=80=A6the code you wrote doesn=E2=80=99t seem=
 like it would
execute in psql.

David J.

--00000000000098c534061c79356b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div>The convention here is to in-line replies, or bottom-post.=C2=A0 Top-p=
osting makes the archives more difficult to read.</div><div><br></div>On Th=
ursday, July 4, 2024, Murthy Nunna &lt;<a href=3D"mailto:mnunna@fnal.gov">m=
nunna@fnal.gov</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" style=3D=
"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">


<div lang=3D"EN-US" link=3D"blue" vlink=3D"purple" style=3D"word-wrap:break=
-word">
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">pg_terminate_backen=
d(pid) will not work as it expects only one pid at a time.=C2=A0</span></p>=
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><br></span></p><p c=
lass=3D"MsoNormal"></p></div></div></blockquote><div>Interesting=E2=80=A6I =
wouldn=E2=80=99t expect the function calls to interact that way=E2=80=A6may=
be try putting the select query into a plpgsql DO command loop and then cal=
l pg_terminate_backend once per loop iteration.</div><div>=C2=A0</div><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #cc=
c solid;padding-left:1ex"><div lang=3D"EN-US" link=3D"blue" vlink=3D"purple=
" style=3D"word-wrap:break-word"><div><p class=3D"MsoNormal"></p><p class=
=3D"MsoNormal"><span style=3D"font-size:12.0pt">So, the question is how to =
rewrite this psql so it loops through all pids one pid at a time?</span></p=
><p class=3D"MsoNormal"></p></div></div></blockquote><div>I can=E2=80=99t t=
ell if you really mean the psql program or are misusing the term to mean so=
mething different=E2=80=A6the code you wrote doesn=E2=80=99t seem like it w=
ould execute in psql.</div><div><br></div><div>David J.</div><div><br></div=
><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1=
px #ccc solid;padding-left:1ex"><div lang=3D"EN-US" link=3D"blue" vlink=3D"=
purple" style=3D"word-wrap:break-word"><div><div><div><div><div>
</div>
</div>
</div>
</div>
</div>
</div>

</blockquote>

--00000000000098c534061c79356b--