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