Changes between Version 2 and Version 3 of Ticket #35028, comment 4


Ignore:
Timestamp:
Dec 12, 2023, 10:52:07 AM (11 months ago)
Author:
Simon Charette

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #35028, comment 4

    v2 v3  
    1 It appears that `psycopg3` will [https://github.com/psycopg/psycopg/blob/52ed68a9d699c1e43e07a4d04441534197552de5/psycopg/psycopg/connection.py#L255-L262 always use server-side cursors] and ignores `cursor_factory` when using a named cursor and we know they are causing issues with how the ORM generates SQL (`DISTINCT`, `GROUP BY`, `ORDER BY`) as it doesn't have proper prepared statement support yet (#20516).
     1It appears that `psycopg>=3` will [https://github.com/psycopg/psycopg/blob/52ed68a9d699c1e43e07a4d04441534197552de5/psycopg/psycopg/connection.py#L255-L262 always use server-side cursors] and ignores `cursor_factory` when using a named cursor and we know they are causing issues with how the ORM generates SQL (`DISTINCT`, `GROUP BY`, `ORDER BY`) as it doesn't have proper prepared statement support yet (#20516).
    22
    33I see a few paths forward here
Back to Top