Re: Invalid idle_in_transaction_session_timeout data type

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: cdalxndr(at)yahoo(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Invalid idle_in_transaction_session_timeout data type
Date: 2021-03-11 12:10:47
Message-ID: 20210311.211047.1106690547580793701.t-ishii@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs

> https://www.postgresql.org/docs/13/runtime-config-client.html
> <https://www.postgresql.org/docs/13/runtime-config-client.html> shows
> that `idle_in_transaction_session_timeout` is integer, bug you can set
> text values '30s' and `show idle_in_transaction_session_timeout`
> returns `30s` not an integer.
> Documentation should be updated to include this data field format.

The documentation says:
"If this value is specified without units, it is taken as milliseconds."

If the value is specified with units, it follows the rule described here:
https://www.postgresql.org/docs/13/config-setting.html

"Numeric with Unit: Some numeric parameters have an implicit unit,
because they describe quantities of memory or time. The unit might be
bytes, kilobytes, blocks (typically eight kilobytes), milliseconds,
seconds, or minutes."
:
:
"Valid time units are us (microseconds), ms (milliseconds), s
(seconds), min (minutes), h (hours), and d (days)."

So I see no problem with the document.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alex 2021-03-11 12:23:29 Re: Invalid idle_in_transaction_session_timeout data type
Previous Message Julien Rouhaud 2021-03-11 12:00:26 Re: Invalid idle_in_transaction_session_timeout data type

Browse pgsql-docs by date

  From Date Subject
Next Message Alex 2021-03-11 12:23:29 Re: Invalid idle_in_transaction_session_timeout data type
Previous Message Julien Rouhaud 2021-03-11 12:00:26 Re: Invalid idle_in_transaction_session_timeout data type