maybe this behavior is related to fetching records using a server-side cursor?
https://wiki.postgresql.org/wiki/Using_psycopg2_with_PostgreSQL#Fetch_Records_using_a_Server-Side_Cursor
I met the same problem using pgjdbc with Oracle SQL developer as descibedherehttps://stackoverflow.com/questions/46066882/autocommit-always-turns-on-in-oracle-sqldeveloper-when-connecting-to-postgresqlorhttps://github.com/pgjdbc/pgjdbc/issues/976
--Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html