Question aboud #80 - itersize in cursor dic

From: Kryklia Alex psycopg(at)postgresql(dot)org Question aboud #80 - itersize in cursor dic 2012-05-16 09:22:25 CAGv7O6PE_u_FRYfq6ycXVLJCtPNc0dqN=UJWT_EZHLYMP5nzqQ@mail.gmail.com (view raw or flat) 2012-05-15 16:59:23 from Kryklia Alex  2012-05-16 09:22:25 from Kryklia Alex   2012-05-16 09:23:48 from Federico Di Gregorio  2012-05-16 10:48:06 from Daniele Varrazzo   2012-05-16 12:45:23 from Kryklia Alex    2012-05-16 12:59:46 from Daniele Varrazzo     2012-05-16 13:36:31 from Kryklia Alex psycopg
```Hi!
Thank for great library.

in psycopg2 extras.py

in 2.4.4 was:
89     def __iter__(self):
90         if self._prefetch:
91             res = _cursor.fetchmany(self, self.itersize)
92             if not res:
93                 return
94         if self._query_executed:
95             self._build_index()
96         if not self._prefetch:
97             res = _cursor.fetchmany(self, self.itersize)
98
99         for r in res:
100             yield r
101
102         # the above was the first itersize record. the following are
103         # in a repeated loop.
104         while 1:
105             res = _cursor.fetchmany(self, self.itersize)
106             if not res:
107                 return
108             for r in res:
109                 yield r
110

in 2.4.5 became:
def __iter__(self):
if self._prefetch:
res = _cursor.__iter__(self)
first = res.next()
if self._query_executed:
self._build_index()
if not self._prefetch:
res = _cursor.__iter__(self)
first = res.next()

yield first
while 1:
yield res.next()

----------------------------------------------------------------------------
and now iterating over named cursor return 1 row, not many

Or how use itersize? (Why itersize not working)

Thank You

Alex

```

psycopg by date

 Next: From: Federico Di Gregorio Date: 2012-05-16 09:23:48 Subject: Re: Question aboud #80 - itersize in cursor dic Previous: From: Egbert Bouwman Date: 2012-05-16 08:17:49 Subject: Re: is it possibile get the psql prompt output?