Re: display hot standby state in psql prompt - Mailing list pgsql-hackers

From Jim Jones
Subject Re: display hot standby state in psql prompt
Date
Msg-id f514ffdd-7596-43a5-9b0e-fe6a91f2d23e@uni-muenster.de
Whole thread Raw
In response to Re: display hot standby state in psql prompt  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-hackers
Hi Greg

On 25.06.25 17:17, Greg Sabino Mullane wrote:
> Seems transaction_read_only might be a more useful thing to examine?
> That's the side-effect, if you will, that people really care about
> when in hot standby mode (and of course, we can get into TRO other ways).

Good point. But wouldn't it mean that I would need to execute a query
every time the prompt is refreshed? Since I cannot get the value of
transaction_read_only via PQparameterStatus. I like the idea, but I'm
concerned about the overhead.

Best, Jim




pgsql-hackers by date:

Previous
From: Ajit Awekar
Date:
Subject: Unnecessary scan from non-overlapping range predicates
Next
From: Álvaro Herrera
Date:
Subject: Re: pg_dump misses comments on NOT NULL constraints