isql -v PostgreSQL_Production postgres mypassword
Before blaming the driver, test the raw connection using isql (Linux/macOS) or the (Windows). odbc driver postgresql
When you enable this setting, the driver changes its internal behavior. Instead of sending a raw SELECT to the PostgreSQL server, it wraps your query in a transaction and uses SQL Cursors. odbc driver postgresql