Changes between Initial Version and Version 1 of Ticket #35028, comment 4
- Timestamp:
- Dec 12, 2023, 10:51:39 AM (11 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #35028, comment 4
initial v1 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 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).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_factor` 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). 2 2 3 3 I see a few paths forward here