Re: Add sub-transaction overflow status in pg_stat_activity - Mailing list pgsql-hackers

From Dilip Kumar
Subject Re: Add sub-transaction overflow status in pg_stat_activity
Date
Msg-id CAFiTN-sRJt2Vrwo5it_=kBg8FZ_4Zsr2_A8vTwHkx44TdYhTNA@mail.gmail.com
Whole thread Raw
In response to Re: Add sub-transaction overflow status in pg_stat_activity  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
On Mon, Nov 14, 2022 at 10:18 PM David G. Johnston
<david.g.johnston@gmail.com> wrote:

>> Do you have a view on this point?
>>
>
> NULL when overflowed seems like the opposite of the desired effect, calling attention to the exceptional status.
Makeit a text column and write "overflow" or "###" as appropriate.  Anyone using the column is going to end up wanting
tospecial-case overflow anyway and number-to-text conversion aside from overflow is simple enough if a number, and not
justa display label, is needed. 

+1, if we are interested to add only one column then this could be the
best way to show.


--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: Add sub-transaction overflow status in pg_stat_activity
Next
From: Peter Smith
Date:
Subject: Re: PGDOCS - Logical replication GUCs - added some xrefs