Due to my connection setup:
ASYNC_URL = URL("postgresql+asyncpg", username=username, password=password, host=host, port=port, database=database)
connectable = AsyncEngine(create_engine(ASYNC_URL, poolclass=pool.NullPool, echo=False, future=True))
I got an error: sqlalchemy.exc.ObjectNotExecutableError. It may be fixed by setting future=False, but then the asyncpg expectation was raised:
File "/Users/path/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 682, in _handle_exception
raise translated_error from error
sqlalchemy.exc.InterfaceError: (sqlalchemy.dialects.postgresql.asyncpg.InterfaceError) <class 'asyncpg.exceptions._base.InterfaceError'>: the server expects 0 arguments for this query, 1 was passed
During running the sync_trigger.
Due to my connection setup:
I got an error:
sqlalchemy.exc.ObjectNotExecutableError. It may be fixed by settingfuture=False, but then the asyncpg expectation was raised:During running the
sync_trigger.