Re: Idle query that's not "<IDLE>"?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Idle query that's not "<IDLE>"?
Date: 2018-11-06 21:11:10
Message-ID: 2f444ae7-ca18-39cf-b450-cb82164ca369@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/06/2018 03:04 PM, David G. Johnston wrote:
> On Tue, Nov 6, 2018 at 1:59 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
>> Right. But when does the query text become "<IDLE>"? Or has that become obsolete? (We recently migrated from 8.4.)
> That behavior changed sometime around 9.0; since it always shows the
> last query executed it logically follows that it will never show the
> placeholder "<IDLE>" (I suppose it might do so upon initial connect if
> no queries have been sent yet...not sure what it says then or even if
> it is possible)

So... obsolete.  Thanks.

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-11-06 21:13:58 Re: backend crash on DELETE, reproducible locally
Previous Message David G. Johnston 2018-11-06 21:04:23 Re: Idle query that's not "<IDLE>"?