Skip to content

Support for proxySQL -> PgSQL server side cursors #5636

@arfathyahiya

Description

@arfathyahiya

I'm trying to stream the data from my postgresql database
But getting

sqlalchemy.exc.NotSupportedError: (psycopg.errors.FeatureNotSupported) only unnamed portals are supported

Sample code

    query = """SELECT * FROM test_table """
    async with Session() as session:
        result = await session.stream(text(query))
        async for partition in result.partitions(chunk_size):
            rows = [dict(row._mapping) for row in partition]
            print(len(rows))

Are there any plans to support this server-side cursors feature?
Is it already available and I have to enable/update something?

$ proxysql --version
2026-04-16 10:28:56 [INFO] Using OpenSSL version: OpenSSL 3.2.2 4 Jun 2024
ProxySQL version 3.0.4-162-gfaa64a5, codename Truls

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions