Timeouts not applied correctly against Neon database

[egoldschmidt]

Steps to reproduce

Setting idle_in_transaction_session_timeout, statement_timeout, and lock_timeout via pg pool config does not appear to work against Neon databases.

Screenshot 1 - params set locally against Postgres 16 in Docker container:

Screenshot 2 - params set against Neon, both direct & pgbouncer:

My methodology is simply to run await pool.query('SHOW lock_timeout');

Note that in screenshot 2 the lock timeout is zero. If I explicitly run SET lock_timeout = ... it works fine.

Expected result

SHOW lock_timeout;

12345ms

Actual result

SHOW lock_timeout;

0

Environment

Production

Logs, links

• Also filed here: Timeouts not applied correctly against Neon database brianc/node-postgres#3604 (comment)