statement_timeout not working for new Pool in dbs mod

[dbauszus-glx]

A pg_sleep query template should timeout when the seconds exceed the default 10000 milliseconds set on the Pool used for client connections in the dbs mod.

"template": "select pg_sleep(%{seconds});"

This doesn't work.

/api/query?template=sleep&seconds=20

Setting an implicit statement_timeout as param does work.

/api/query?template=sleep&seconds=20&statement_timeout=1000

[dbauszus-glx]

Resetting the statement_timeout prior to releasing the client doesn't seem to do anything. The client returned from the pool connect will not have the previously set statement_timeout.

The query_timeout option for the pool does kill the client request.