public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Murthy Nunna <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: psql help
Date: Thu, 4 Jul 2024 22:19:35 -0700
Message-ID: <CAKFQuwaEb004d7ODhPbFZ+uz724=85pGjR7TNNGGpSoiH1Cb0Q@mail.gmail.com> (raw)
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>

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 <[email protected]> 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.

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: psql help
  In-Reply-To: <CAKFQuwaEb004d7ODhPbFZ+uz724=85pGjR7TNNGGpSoiH1Cb0Q@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox