asyncpg

asyncpg copied to clipboard

text encoding of composite types error with schema and table name.

1

* **asyncpg version**: 0.23.0 * **PostgreSQL version**: 10.13 * **Do you use a PostgreSQL SaaS? If so, which? Can you reproduce the issue with a local PostgreSQL install?**: No. I...

Ranc58

asyncpg.exceptions._base.InterfaceError: cannot perform operation: another operation is in progress when executing gino processes in parallel

8

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

shsimeonova

Does not work on ASGI servers

4

* **asyncpg version**: 0.21.0 * **PostgreSQL version**: 13 * **Do you use a PostgreSQL SaaS? If so, which? Can you reproduce the issue with a local PostgreSQL install?**: N/A (No)...

cheesycod

column reference X is ambiguous

1

Hello everyone 👋 Migrating from psycopg2 to asyncpg, I'm facing an issue with an `executemany`. Here is my example: Table structure: ``` CREATE TABLE table_name ( column1 text PRIMARY KEY,...

RichardFevrier

add type for pool.acquire()

3

Tynukua

Is it possible to specify multi hosts dsn for connection pool?

19

Is it possible to connect to several hosts (one master and replicas) from ConnectionPool (interface like libpq provides)? I mean the following: https://www.postgresql.org/docs/current/static/libpq-connect.html ``` # Read sessions postgresql://host1:123,host2:456/somedb?target_session_attrs=any # Read-write...

alvassin

asyncpg.exceptions.UndefinedFunctionError: function pg_listening_channels() does not exist

4

this is error message ``` Traceback (most recent call last): File "/home/gt/workspace/algo_syncer/base/async_pg.py", line 81, in loop.run_until_complete(run_query('SELECT 1')) File "/usr/lib/python3.6/asyncio/base_events.py", line 473, in run_until_complete return future.result() File "/home/gt/workspace/algo_syncer/base/async_pg.py", line 65, in...

shuai93

decimal.InvalidOperation exception is thrown with AWS Redshift.

1

* **asyncpg version**: 0.23.0 * **PostgreSQL version**: PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.27314 * **Do you use a PostgreSQL SaaS?...

ohhara79

set_type_codec() doesn't work with copy_records_to_table()

1

* **asyncpg version**: 0.23.0 * **PostgreSQL version**: 9.5.21 * **Do you use a PostgreSQL SaaS? If so, which? Can you reproduce the issue with a local PostgreSQL install?**: No and...

SamuilDichev

Implement AsyncContextManager for connection

1

Ideally, the following code would work: ```py import asyncpg async def main(): async with asyncpg.connect() as conn: # await conn.execute("SELECT") ``` Instead, the connection must be managed manually.

pauldraper