Limit of the number of retrieved rows?

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--===============1643366544==
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enig9DCB24ABC6F2F59BEDDBA830"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig9DCB24ABC6F2F59BEDDBA830
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 =3D cursor.fetchone()

while (data):

    #a lot of nasty instructions
    consulta =3D 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


--------------enig9DCB24ABC6F2F59BEDDBA830
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIMCNszOXzq7sfm9ARAtMIAJ966IO/ZsoliCaBCnTmN/ZhrNFSBACbBLb3
6VXqm2grhqxzsLxTQ9AdEhk=
=q5uh
-----END PGP SIGNATURE-----

--------------enig9DCB24ABC6F2F59BEDDBA830--


--===============1643366544==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft 
Defy all challenges. Microsoft(R) Visual Studio 2008. 
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
--===============1643366544==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Pypgsql-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pypgsql-users

--===============1643366544==--