-Original Message-
From: dep...@depesz.com
Sent: Friday, July 5, 2024 6:05 AM
To: Murthy Nunna
Cc: pgsql-general@lists.postgresql.org
Subject: Re: psql help
[EXTERNAL] – This message is from an external sender
On Fri, Jul 05, 2024 at 03:54:56AM +, Murthy Nunna wrote:
> So
On Fri, Jul 05, 2024 at 03:54:56AM +, Murthy Nunna wrote:
> Sorry, there is no problem with the following statement and the environment
> variable. It works fine. But it terminates only one PID due to LIMIT 1. I
> want to terminate all pids that meet this criteria. If I remove LIMIT 1,
> pg_
"David G. Johnston" writes:
> On Thursday, July 4, 2024, Murthy Nunna 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
TBH, my reaction to that was that the OP doesn't understand
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 wrote:
> pg_terminate_backend(pid) will not work as it expects only one pid at a
> time.
>
>
> Interesting…I wouldn’t expect the function cal
On 7/4/24 20:54, Murthy Nunna wrote:
Sorry, there is no problem with the following statement and the
environment variable. It works fine. But it terminates only one PID due
to LIMIT 1. I want to terminate all pids that meet this criteria. If I
remove LIMIT 1, pg_terminate_backend(pid) will not
n
Sent: Thursday, July 4, 2024 8:17 PM
To: Murthy Nunna
Cc: pgsql-general@lists.postgresql.org
Subject: Re: psql help
[EXTERNAL] – This message is from an external sender
On Thu, Jul 4, 2024 at 4:56 PM Murthy Nunna
mailto:mnu...@fnal.gov>> wrote:
How can I rewrite the above in psql
On Thu, Jul 4, 2024 at 4:56 PM Murthy Nunna wrote:
>
>
> How can I rewrite the above in psql
>
The only real trick is using a psql variable instead of the shell-injection
of the environment variable. Use the --set CLI argument to assign the
environment variable to a psql variable then refer to
