itersize not honored when using named cursor with RealDictCursor

[psycoteam]

Originally submitted by: Jean-Baptiste Quenot

Consider the following program with the default implementation of RealDictCursor:

import psycopg2.extras
conn = psycopg2.connect('dbname=test', connection_factory=psycopg2.extras.RealDictConnection)
curs = conn.cursor('unique_name')
curs.itersize = 2000
curs.execute("select * from foo limit 25")
curs.fetchone()

The output with PSYCOPG_DEBUG=1 contains the following lines:

[0x7f603d53c700]     FETCH FORWARD 1 FROM "unique_name"

I have to override the Cursor class like this to fetch the proper number of rows:

class Cursor(psycopg2.extras.RealDictCursor):
    def next(self):
        return psycopg2.extras._cursor.next(self)

class Connection(psycopg2.extras._connection):
    """A connection that uses `Cursor` automatically."""
    def cursor(self, name=None):
        if name is None:
            return psycopg2.extras._connection.cursor(self, cursor_factory=Cursor)
        else:
            return psycopg2.extras._connection.cursor(self, name, cursor_factory=Cursor)

conn = psycopg2.connect('dbname=test', connection_factory=Connection)
...

The debug output is OK:

[0x7f86ba488700]     FETCH FORWARD 2000 FROM "unique_name"

[dvarrazzo]

Fixed in my devel branch, thank you for the report.

[psycoteam]

Originally submitted by: ecigarette2012

Dreambox DM800 HD PVR
dm800
800hd
dreambox dm800hd
dm 800 hd
dm 800 hd pvr
dreambox hd
dreambox 800 hd
dm 800
dreambox dm 800 hd pvr
dreambox dm 800 hd
dreambox 800
dm800hd
dreambox dm800
dm800 hd pvr
Dreambox DM800C

Dreambox dm800S
dreambox 800s

Dreambox DM500S

dm500S
dm 500S
dm500
dreambox 500
dreambox 500s
dm500c
Dreambox dm500T
Dreambox DM500T

ORTON HD X403P

Dreambox DM500Si

electronics cigarette

electronic cigarette liquid premium

electronic cigarette electronic

cigarette manufacturer

cheapest electronic cigarette

china electronic cigarette

electronic cigarette reviews

electronic cigarette starter kits

electronic cigarette price