Is there a way to specify lock_timeout per pool?

[daicoden]

trafficstars

When PG Cat is in transaction mode there's no way to set a lock_timeout on the client connection.

We want to set a lock_timeout for all connections for various pools without having to put the lock_timeout in the postgres.conf. It seems like this should be a way to specific the psql connection options per pool.

[magec]

There is not way to set these parameters using pgcat pool configuration. The only way you could do this is by using session pooling and execute SET commands on the session preparation. If you use transactional pooling, session altering parameters are cleaned up using a RESET ALL when the connection is returned to the pool.