db manager: fix connection holding - idle in transaction (QGIS bug #7162...

Fix to ticket #7679 .

Here is a working patch which will fix connection holding issue by setting DB Manager connection to AUTOCOMMIT isolation level (which is better practice). I have removed named cursor usage in PGTableDataModel._createCursor to fix problems when running with AUTOCOMMIT.