Re: proposal: psql: psql variable BACKEND_PID - Mailing list pgsql-hackers

From Jelte Fennema
Subject Re: proposal: psql: psql variable BACKEND_PID
Date
Msg-id CAGECzQS4OGomdGeCrH07PH6y8wCmgFkBD=kObAHYFJXA-sV4ZQ@mail.gmail.com
Whole thread Raw
In response to Re: proposal: psql: psql variable BACKEND_PID  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proposal: psql: psql variable BACKEND_PID
List pgsql-hackers
On Thu, 16 Feb 2023 at 12:44, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> To find and use pg_backend_pid is not rocket science. But use :BACKEND_PID is simpler.

I wanted to call out that if there's a connection pooler (e.g.
PgBouncer) in the middle, then BACKEND_PID (and %p) are incorrect, but
pg_backend_pid() would work for the query. This might be an edge case,
but if BACKEND_PID is added it might be worth listing this edge case
in the docs somewhere.



pgsql-hackers by date:

Previous
From: John Naylor
Date:
Subject: Re: Considering additional sort specialisation functions for PG16
Next
From: Etsuro Fujita
Date:
Subject: Re: Some revises in adding sorting path