prepared statement "asyncpg_stmt_1__" already exists error

[ghost]

I have problem with prepared statement "asyncpg_stmt_1__" already exists. I created the pool with statement_cache_size=0 but somehow it works when I first ran it, then the 2nd time it will not work.

pool = await asyncpg.create_pool(<uri>, statement_cache_size=0)
async with pool.acquire() as conn:
        async with conn.transaction():
            async for record in conn.cursor("SELECT * from abc"):
                print("here")

• asyncpg version: 0.2.6.0
• PostgreSQL version:
• Python version: 3.9.13
• Do you use pgbouncer?: yes
• Did you install asyncpg with pip?: poetry

[ghost]

The problem is related to prepared statement and pgbouncer, it doesn't have any problem with the lib, so I close this.