Skip site navigation (1) Skip section navigation (2)

Named cursor problem

From: Vojtěch Rylko <rylko(at)vojtuv(dot)net>
To: psycopg(at)postgresql(dot)org
Subject: Named cursor problem
Date: 2012-01-30 16:09:15
Message-ID: 4F26C0AB.1030603@vojtuv.net (view raw or flat)
Thread:
Lists: psycopg
Hi,

I am using named cursor in this manner:

cursor = conn.cursor(str(os.getpid))
cursor.execute("select * from documents;")
for row in cursor: print do_something(row) # this function also creates 
cursors from "conn"

One million rows have to be processed, but after 10-20 thousands 
processed rows I got an error:
Traceback (most recent call last):
   File "/homes/eva/xr/xrylko00/spinn/spinn3r/db/db2xml.py", line 408, 
in <module>
     query = query)
   File "/homes/eva/xr/xrylko00/spinn/spinn3r/db/db2xml.py", line 351, 
in create_xml
     for item in self.get_item(column, identifiers, query):
   File "/homes/eva/xr/xrylko00/spinn/spinn3r/db/db2xml.py", line 172, 
in get_item
     for row in cursor:
ProgrammingError: named cursor isn't valid anymore

Where may be problem?

PostgreSQL 8.4.9 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 
4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit
Python 2.6.5 (r265:79063, Jun 22 2010, 14:35:26)
[GCC 4.3.5] on linux2
 >>> import psycopg2
 >>> psycopg2.__version__
'2.2.2 (dt dec ext pq3)'

Cheers,
Vojtěch R.

Responses

psycopg by date

Next:From: Federico Di GregorioDate: 2012-01-30 16:13:17
Subject: Re: Named cursor problem
Previous:From: Peter IrbizonDate: 2012-01-17 16:56:01
Subject: Re: after application close MS Visual C++ runtime library error occurs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group