Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lKKxS-0007qo-W8 for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Mar 2021 13:02:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lKKxR-00028M-Vd for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Mar 2021 13:02:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lKKM4-00020G-Qr for pgsql-bugs@lists.postgresql.org; Thu, 11 Mar 2021 12:23:53 +0000 Received: from sonic316-20.consmr.mail.ne1.yahoo.com ([66.163.187.146]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lKKLy-0005Es-3K for pgsql-bugs@lists.postgresql.org; Thu, 11 Mar 2021 12:23:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1615465424; bh=AqXRDqItNQ/bemKd55ISJp/HDr18MMiuOp1M+L2rluo=; h=From:Subject:To:Cc:References:Date:From:Subject:Reply-To; b=AtGENpktJb0c0tFDu1rJTdcGDZT+5UEK11l1UVqs7ojzh7kXaihH6h9lIzMJnNWi6RDDIXM4uXXvTreNkW/joTpjggfx8S/tYKkf4EKhTCQ4b/4PWeejmU8m9+r4DImsutv6S4Nf+st51kB84dP+YqYL+l8fUzYIDlVfQA5iqoiHsKra7+5UXD17pOcCuVyG3fvCx6RPvqAf4lxyL4TytPETQ+OO/246+De76GuPaI4lbUhqB8cxh11U2Yn7pdFnOoYC8Bfq1wa/ExImfvl3e32ddERNNYmJCKsE+zWT7KOoC2cSk5XrTvWm84uU9rxDl/6QXChBbnSValRhZCM+2A== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1615465424; bh=BBufRn3oUayUhCgz2tXt9qtVliwOtVFC1lDDtc2JNpA=; h=X-Sonic-MF:From:Subject:To:Date:From:Subject; b=lM5BnUMaH3Fz6jPleNTrBLbTmoL8iii9aoGOV120qRHfKbFGwrh3BDaY/ApinnucHqm9DACzXcFi3gMJbGu4Qql5sFFc/+VjIcFqRjUUOPMLlUehW9s2sAtkALv2K7HxWGnoGY/LA/zi/Ils9nMrM6Z9bWzjHx+4k+fKWQfPDKfPEAafA798eFruyEDqvlmCdayUJlq8d9BQuO14pMP4dLEDtc1YGeBc8yqXHMNwr04VHtEpJZrdkzqrgxwCys9eX8H0JOjr/kG3W9TtPETiJGQv/QgbBsCsgn5DmNOzjjiYAn7ODJXZrw82KlsR7+BERtLpbRyf+upMPjU26p/8zg== X-YMail-OSG: I4OGvUUVM1kCcmvXcZR8Fdzigz8NpPBpgyJlbq5lc3Cw5LnRa7_Zu3Naf3FJXB9 yFy0LsqpU2gztJdn_YDpuNJSOnpVPpCfQhbfKLrC4X_PbAuz2rTciveGWYJTdUtWSrIfgAXC2uZd PeAIw4rHLay4ciwv46yELX.hJDyk2cqNRAQZVuyhUFdW2K7sDwVE_QxpxamtbDjzkeKuTcjAQL1M wSjldaZLgIjyOlOXXFnvzfASXmVXFvP.AGTZbtL5.6zTD9Wu3qNGLFh7voR0ywYbmAvDLXdOQYR9 MhLzqIa.xj78MQFe4JvEbfybv1SiGLqWg7QcgFFQzPY.BxHh9etu_x6vNHbLGN..j.es0rMMprmg YZIIL35LVxHnhSkuC9XXZSgHMQnPL.hN112KIxIC4u6O_IXHVxGmWXr4No_8g_H94GHUVLR63R3b eS3Via.VzPie4.tu_OvigkrIoXHdN8TjSUEUPCS_LtnFDOPXaXW37a18kaz7EU2oeYsnMUS5oYUc 3K4d9nq_MKSLoglZrBMysPr2AJiXsyAIeawQwvY0LnQiMCDC0k5dT5kLk7rvabmjUPsTn9BbnJbJ 3lvXywAaR_tikCjfBnG5ciyCJJrlJQ6Tp3QMTmw5x73jNiLk_xtLt5SRO9TOX2wp7NzHq0X2o.EZ bDF8Id.PLElRMqHsCQsb9D8E55f6JL2PeGLNUsGTcGic84LkAqCzKVCuRFXIqXttKN.kfjTYGJl_ sGnA6JSPhaX0s8QDkS92Hecb.a6CdqZzNWRtcbkIosqR.jymTh5CeALfw7RhsAmxlXX0CL2xFtlR wQPqcoxIPdiqllXiWMTUrFzP6pjhcmeYgrAV1Hn6t13vCOtl8z8mGNTwFT9LTDYIEHrjx00jbion fDta7j_JuzmUftGDp3kluCE.wnFFstIqRw8dn4fK1hc87ZMBqNVm6w6HDy5b0Fat.RHDGtGtnPZx Ktc5PbvfiJ1UgBGMqEqAzMXp51jy6J.xi85KSecYv.oIofFOezZs6U7gSS9Es8YsPKW8BmHT3oKh jE66t3Si5Hh73bM4PLxT7rfFwsi5g48la2HIDY8tzxVoKLkgBbYrhDze0wA6Wt7V6si9LjTMMtKg 7L1r3xZ_WGTPSZobnucchZ7bxFQK9ZIUN.YhOXJf.36g6JIF13ekhE1_QbhuH9Oz5FZu0tGekrEC NI2mhwGP32jaDuItRhhbTYIWbg8YQKxXWX8OMYgV1fyPuiaq7LWA1VFh7egKD3mTLGSrbO.TSOgB JHt5IPKZGlFRJIDkZnHdM9rGvqlDelkmiJ0vIubX0DJR5uQvcXcgDmRSI37YZdR0WGo.sIVfvyXq 8ySw2dPozuRFJ44cyzZgZWhBc4kuKK2RhW7jEiS07g89c68EpNQdaNcB81AEsJz8IypN8aIxJgbw RW.uOgDVbSTas1vkO6dxrimn5V9VSKHlwCBeWg6M17YVLuD.KU.AJrjPkd1u46VU1Sk2OU0NNPNU n7QCYilc7xdqzXwQQtSczqNguNliX6dw5wfqK6MoOnNw3ofqp6BTZ5pYJ2eHX4_JisFrakZaDr1p uN28mm_CdO7Myf28slN77cJYB_ilJQGJzucNYTtBKDCPQchMXZLU4LINFZeZGCTqPGAI2TjUzlrt 3tznqNl6vpyR2mlPaG6sdP1R8UhHPd7MC3ADL4EhdKjLux6lIUrjKNRsSG8RbnLzOSP2NmrJGVg_ dWnQdA1u_Q1KV9KBFxveCBN.GChCPiiZldKNo2N8pobkJMFoPguFVusFIW0Cjh9kQVCt2jtV58JU 5wP.uXKmG5OIWoddfnSz5FF7d9fU9pNviAfkpP5IASnzmaAl3pmCYXW_q8So0rkqw3cEFFZEDgJJ ebck6zufDuEfBgm7Zc.N4ULL8HdqQQKvz.C3kfjR8LaR7W8yh8oxFjvzNlcpDTGw15QekQsOUPCw BXjm8VGkn62N1RKq0O6rnpqvx1uQgs59zux4pbLz0R8hyY922RTglLfoISX8.Iq7SUJY9PSveYOX V_oFUdr_RFfgXqHVVgZyZSXxs_CQRQ2.NbtwrLA.fi3JIZlhcKTVtEpq4BrmLNHRnmlTLr9SOP1M qcYJi3LV9PkEnApUf2gScIumtxL69DT3Dsd4GHLpIxEcRVu7AJB0Ugy32sFEKMWert96QgROUkX8 2IgWs6UpLIIG_DP_SRQlJAEVuJQJN09hWoIxryr.uHuQOY7oAOqeCExMbQRDCGU0EyyAPn1jb_oZ OEvEA5oiyEjs5NQzJd8hbvkQmzdXYQ.I7ERBC_YcGvg2_.xffBGTtbqcPn.XCuTk4S92vmrN5Uhu 9EBl4HKCXldftogVJ9eJZY1eantgsmQtnf.bMsfV8zxwI3ZCncnw6QQgjAHizqDL_vxqFkF6PenY CYoDlroZA2QW6cvm.XWxdP24TcNyBjyDJ2A2ISh9EiFPT0Ga1HvGObHfs7oamw8nFiPaaqTV7HHY SDRptI4PPqwYsEc2jE4EAAWJR_a4bH1TOh.BBtgh9NpQ1Br8.91U8fQs9xKnosFcoyPOkhK_43Yg SyO.n_nGtWAGCzGs5C47v18M- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.ne1.yahoo.com with HTTP; Thu, 11 Mar 2021 12:23:44 +0000 Received: by smtp416.mail.ir2.yahoo.com (VZM Hermes SMTP Server) with ESMTPA ID 1bd7b182df911b02968586f79fe2c2c3; Thu, 11 Mar 2021 12:23:33 +0000 (UTC) Content-Type: multipart/alternative; boundary="----sinikael-?=_1-16154654098540.16446627942935055" From: Alex Subject: Re: Invalid idle_in_transaction_session_timeout data type X-Type: replyAll To: Tatsuo Ishii Cc: pgsql-bugs@lists.postgresql.org User-Agent: Desktop Message-Id: References: <11783b8644ae5.7f3aa1e3b18b4.ref@yahoo.com> <11783b8644ae5.7f3aa1e3b18b4@yahoo.com> <20210311.211047.1106690547580793701.t-ishii@gmail.com> Content-Transfer-Encoding: quoted-printable Date: Thu, 11 Mar 2021 12:23:29 +0000 MIME-Version: 1.0 X-Mailer: WebService/1.1.17927 mail.backend.jedi.jws.acl:role.jedi.acl.token.atz.jws.hermes.yahoo Apache-HttpAsyncClient/4.1.4 (Java/11.0.9.1) Content-Length: 5670 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------sinikael-?=_1-16154654098540.16446627942935055 Content-Type: text/plain; format=flowed Content-Transfer-Encoding: 7bit In my opinion, it would be more clear if "Numeric with Unit" would be specified on that property documentation, so that I can search more about what that means (eventually a link pointing to details). I saw "(integer)" so I assumed `show idle_in_transaction_session_timeout ` will return an integer. To actually deduce its format I should read much more documentation, and the average user usually fast searches and scans documents only for keywords. Tatsuo Ishii wrote: 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 ------sinikael-?=_1-16154654098540.16446627942935055 Content-Type: text/html; format=flowed Content-Transfer-Encoding: 7bit
In my opinion, it would be more clear if "Numeric with Unit" would be specified on that property documentation, so that I can search more about what that means (eventually a link pointing to details).
I saw "(integer)" so I assumed `show idle_in_transaction_session_timeout ` will return an integer.
To actually deduce its format I should read much more documentation, and the average user usually fast searches and scans documents only for keywords.



Tatsuo Ishii wrote:



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:

"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
------sinikael-?=_1-16154654098540.16446627942935055--