Elvis Pranskevichus

Results 335 comments of Elvis Pranskevichus

Not at the moment, but contributions are always welcome! :-)

Please provide error traceback. Does your `UPDATE` involve a temporary table? What does the query actually look like?

Well, asyncpg itself does not attempt to access any "session_vars" table, so this must be an application error.

Please provide a more elaborate example. Enum types in composites, as well as enum types returned by functions work as expected for me in these tests: https://github.com/MagicStack/asyncpg/blob/2fc50e48e1838b2d2eeabfa0ed3722896c48e349/tests/test_codecs.py#L1627-L1664

Your issue appears to be because some of your queries return an enum value in an anonymous record. Here's a script that reproduces this: ```python import asyncio import asyncpg async...

Preloading wouldn't help with nested anonymous composite types: you can't enumerate them reasonably.

It's likely an SQLAlchemy bug. The host argument must be a list of strings. /cc @CaselIT, @zzzeek

This is a bug in SQLAlchemy's [`create_connect_args` implementation](https://github.com/sqlalchemy/sqlalchemy/blob/5e416bfa91e7dcba5a0adb5f275341ac9f83fe81/lib/sqlalchemy/dialects/postgresql/asyncpg.py#L957) for asyncpg.

> Seems that SQLAlchemy folks expect DBAPIs to have the standard param names for `connect`. It is weird for SQLAlchemy to require that, given that it's supposed to be an...

`max_inactive_connection_lifetime` is used to automatically close __unused__ connections in the pool after a period of inactivity. Please provide an example of the code that triggers this.