FR: connect_timeout in Connection URIs

[Andrei-Pozolotin]

1. the following snippet:

import asyncpg
await asyncpg.connect(dsn=data_conn)

2. works with application_name:

data_conn="postgresql://postgres:postgres@data-serv-0:5432/postgres?application_name=simple"

3. and fails with connect_timeout:

data_conn="postgresql://postgres:postgres@data-serv-0:5432/postgres?application_name=simple&connect_timeout=3"

asyncpg.exceptions.UndefinedObjectError: unrecognized configuration parameter "connect_timeout"

despite both application_name and connect_timeout should be valid options:
https://www.postgresql.org/docs/12/libpq-connect.html#LIBPQ-CONNSTRING

[elprans]

connect_timeout is not a server setting, it's a libpq setting, and asyncpg does not use libpq. You should pass the timeout keyword argument to connect() instead. This is documented here.

[Andrei-Pozolotin]

1. yes, I have seen that doc
2. my point is that this is design error