Prepared statements with connection pool

Personne n'a encore pris cette issue.

Hi, I have troubles using prepared statements with connection pool. AFAIK you have to setup prepared statement for each connection you are using (https://www.postgresql.org/docs/9.3/static/sql-prepare.html):

> Prepared statements only last for the duration of the current database session. When the session ends, the prepared statement is forgotten, so it must be recreated before being used again. This also means that a single prepared statement cannot be used by multiple simultaneous database clients; however, each client can create their own prepared statement to use.

So what is preferred way to work with prepared statements with connection pool? Should I, after connect, prepare statements for each connection of connection pool (how to iterate them?)? Should I use `setup` keyword of `create_pool`? But that is called each time `acquire` and we do not get references to statements easily. How to handle statement references? Dict of connection: statements?
Is there a way to do it with `asyncpg`? Could you send me an code example how to do it or even better add it to documentation?

Start by reading the connection-pool create_pool API and its setup callback, then review the prepared-statement behavior described in the issue. A useful outcome would be a documented asyncpg example explaining how prepared statements should be handled with pooled connections, including how statement references are managed.

Rédigé par le modèle d'indexation à partir du texte de l'issue.