Temporary tables still visible after releasing connection to pool

It seems like releasing a connection back to the pool doesn't entirely reset its state in a way that makes it brand new for the next user. Is it expected that temporary tables are still visible? Temporary tables in PostgreSQL are dropped after the session exits but wondering if there is a missing incantation in Connection.reset() that will allow it to be reused.

import asyncio

import asyncpg


async def main():
    pool = await asyncpg.create_pool(
        ...
        min_size=1,
        max_size=1,
    )

    async with pool.acquire() as conn:
        await conn.execute("CREATE TEMPORARY TABLE foo(id INT PRIMARY KEY)")

    async with pool.acquire() as conn:
        await conn.execute("CREATE TEMPORARY TABLE foo(id INT PRIMARY KEY)")  # DuplicateTableException


asyncio.run(main())

Inizia eseguendo la riproduzione asyncio fornita con un pool a una sola connessione, quindi esamina Connection.reset() e il percorso di acquisizione/rilascio del pool. Determina se il rilascio di una connessione debba rimuovere la tabella temporanea e fai in modo che il comportamento corrisponda alle aspettative documentate sul reset del pool, usando la riproduzione come verifica del completamento.