When autocommit is off, the driver issues an implicit BEGIN before the first statement.
: Using UseDeclareFetch=1 forces every SELECT to become a server-side cursor, which can cause massive temp file usage if the result set is large and you scroll backward. odbc postgresql driver
This piece explores the driver’s architecture, protocol mapping, configuration nuances, performance characteristics, and modern limitations. When autocommit is off, the driver issues an
And the matching /etc/odbcinst.ini :