Re: Add sub-transaction overflow status in pg_stat_activity

Поиск
Список
Период
Сортировка
От Dilip Kumar
Тема Re: Add sub-transaction overflow status in pg_stat_activity
Дата
Msg-id CAFiTN-sRJt2Vrwo5it_=kBg8FZ_4Zsr2_A8vTwHkx44TdYhTNA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add sub-transaction overflow status in pg_stat_activity  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Dilip Kumar
Дата:
Сообщение: Re: Add sub-transaction overflow status in pg_stat_activity
Следующее
От: Peter Smith
Дата:
Сообщение: Re: PGDOCS - Logical replication GUCs - added some xrefs