[Pypgsql-users] Limit of the number of retrieved rows?

[David J. B. <shh...@gm...>]

Hi.

First, sorry for my english as I'm not english speaker and I have not
practised it for a while.

I have a table with more than 36 millions of rows, and I'm executing a
very simple query (Select * from table) to retrieve all the data and
porcess it in python.

The problem is that when I have the results, the program only processed
35.999.999 rows. I have tried some versions of my script and it always
process 35.999.999 rows.

My script is as simple as

cursor.execute("SELECT * FROM table")

data = cursor.fetchone()

while (data):

    #a lot of nasty instructions
    consulta = cursor.fetchone()

I have been debugging my script for a while, but I can't imagine where
is the problem (it's difficult to debug more than 36 millions of rows)
and I'm wondering if there's some limit for pypgsql (or postgre) because
the number 35.999.999 seems a little bit curious...

Thanks for the help.
---
David J. Brenes