From: | maplabs(at)light42(dot)com |
---|---|
To: | psycopg(at)postgresql(dot)org |
Subject: | Named Cursor Basics |
Date: | 2011-05-19 20:52:11 |
Message-ID: | 20110519165211.3fg43tllf4sk0www@webmail.light42.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | psycopg |
Hi All-
thanks for the re-invigoration of psycopg2.. looking forward to
great things..
I have a big, big table, and I want to iterate through each record once. I am
not clear on using named cursor and pages though..
I tried a simple example late last night, and it iterated twice
then stopped.
Today, after a bit more reading, I tried again in the interactive
shell, but got
OperationalError: cursor "tmp" does not exist
There is something I am missing.. this is so fundemental..
executing a select * on the table with a non-named cursor does not appear
to be an option..
I have psycopg2 2.4.1 built from source and installed on linux. Pg 9
thanks
-Brian
From | Date | Subject | |
---|---|---|---|
Next Message | Federico Di Gregorio | 2011-05-20 05:11:42 | Re: Named Cursor Basics |
Previous Message | Daniele Varrazzo | 2011-05-16 23:11:16 | Re: Trouble installing psycopg2 on Mac OSX 10.6 |