| From: | Federico Di Gregorio <federico(dot)digregorio(at)dndg(dot)it> |
|---|---|
| To: | psycopg(at)postgresql(dot)org |
| Subject: | Re: Named Cursor Basics |
| Date: | 2011-05-20 05:11:42 |
| Message-ID: | 4DD5F80E.6000908@dndg.it |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | psycopg |
On 19/05/11 22:52, maplabs(at)light42(dot)com wrote:
> 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
Can you show us the code?
federico
--
Federico Di Gregorio federico(dot)digregorio(at)dndg(dot)it
Studio Associato Di Nunzio e Di Gregorio http://dndg.it
I porcellini di terra sono davvero Crostacei! Non lo sapevo!
Certo che sono crostacei, hanno la crosta!
Allora la pizza è un crostaceo?! -- discorso all'ESC2k07
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maxim Avanov | 2011-05-27 17:42:51 | Negative Integers Escaping |
| Previous Message | maplabs | 2011-05-19 20:52:11 | Named Cursor Basics |