asyncpg

asyncpg copied to clipboard

Support composite types with fields that are of type `citext`

1

* **asyncpg version**: 0.28 * **PostgreSQL version**: 15 * **Do you use a PostgreSQL SaaS? If so, which? Can you reproduce the issue with a local PostgreSQL install?**: Local version...

kevinvalk

asyncpg supports an explicit server_options=... dict connection method parameter, but does not seem to populate its value from the PGOPTIONS environment variable. This is a feature request for it to...

dfuhry

Segfault protocol.cpython

2

* **asyncpg version**: 0.27.0 * **PostgreSQL version**: PostgreSQL 15.2 (Debian 15.2-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit * **Do you use a PostgreSQL SaaS? If so,...

vitassuper

Memory leak with Pool usage

1

* **asyncpg version**: 0.27 * **PostgreSQL version**: 14 * **Do you use a PostgreSQL SaaS? If so, which? Can you reproduce the issue with a local PostgreSQL install?**: no *...

timberkerkvliet

`TypeError: cannot unpack non-iterable NoneType object` when using docker bridge network

1

--- * **asyncpg version**: 0.27.0 * **PostgreSQL version**: 12 * **Python version**: 3.8 * **Platform**: Ubuntu 22 * **Do you use pgbouncer?**: no * **Did you install asyncpg with pip?**:...

thentgesMindee

Difference between bulk update with FROM VALUES and without it?

1

```python3 await conn.executemany( """ UPDATE user SET login=$2, name=$3, age=$4, sex=$5 WHERE id=$1 """, users, ) ``` ```python3 await conn.executemany( """ UPDATE user SET login=actual_user.login, name=actual_user.name, age=actual_user.age, sex=actual_user.sex FROM (VALUES...

wowka1319

allow name parametr llike this!

2

Like this: "SELECT company FROM company WHERE approved=%(approved)s" not this : SELECT company FROM company WHERE approved = ${approved} not this : SELECT company FROM company WHERE approved = $1...

koshak01

asyncpg.connect() type is Coroutine[Any, Any, Any]

1

I was expecting asyncpg.connect() to have a concrete type, but I'm new to python and I may be overlooking something obvious. Thank you.

lukepighetti

asyncpg.exceptions._base.InterfaceError: cannot call Connection.fetch(): connection has been released back to the pool

4

* **asyncpg version**: 0.26.0 * **PostgreSQL version**: 12.0 * **Do you use a PostgreSQL SaaS? If so, which? Can you reproduce : NO, from pg docker the issue with a...

iyuhang

Await connection in debugpy

1

* **asyncpg version**: 0.27.0 * **PostgreSQL version**: 15.1 * **Do you use a PostgreSQL SaaS? If so, which? Can you reproduce the issue with a local PostgreSQL install?**: * **Python...

ekeric13