On Sunday, February 9, 2025, Mukesh Tanuku <mukesh.postg...@gmail.com> wrote: > > > > *idle_in_transaction_session_timeout = '1min'idle_session_timeout = '5min'* >
I suspect our docs may need an update. They say you may include white space before the unit; it probably needs to be changed to “must”. I believe we’ve recently tightened up the parsing of literals in this area. > > other way also, like below > > *idle_in_transaction_session_timeout = 60000idle_session_timeout = 300000* > If those give error messages regarding trailing junk something else must be going on. > > we see these errors reporting in the logs after we enabled those parameters > *log:* > 2025-02-10 04:17:19.156 GMT [2467573] ERROR: trailing junk after numeric > literal at or near "1m" at character 43 > 2025-02-10 04:17:19.156 GMT [2467573] STATEMENT: SET > idle_in_transaction_session_timeout = 1min > 2025-02-10 04:17:19.845 GMT [2467575] ERROR: trailing junk after numeric > literal at or near "1m" at character 43 > 2025-02-10 04:17:19.845 GMT [2467575] STATEMENT: SET > idle_in_transaction_session_timeout = 1min > ... > David J.
