Fetching data from binary cursor

From: Tom Kazimiers <tom(at)voodoo-arts(dot)net>
To: psycopg(at)postgresql(dot)org
Subject: Fetching data from binary cursor
Date: 2017-07-21 18:49:20
Message-ID: 20170721184920.75hboryinmgdekyw@macberry.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hi,

I am using Psycopg 2.7.1 from a Django application. To improve the
performance of some very large queries I want to test server-side binary
cursors and when I try to fetch results from it, I run into this error:

rows = cursor.fetchall()
ValueError: invalid literal for long() with base 10: ''

This is what I do:

from django.db import connection

cursor = connection.connection.cursor()
cursor.execute('''
DECLARE test_cursor BINARY CURSOR FOR
SELECT * FROM treenode
''')
cursor.execute("""FETCH 1 FROM test_cursor""")
rows = cursor.fetchall()

The cursor I get from Django (connection.connection.cursor()) is a
genuine Psycopg2 cursor:

> type(cursor)
psycopg2.extensions.cursor

Is there something I am doing wrong?

Thanks,
Tom

Responses

Browse psycopg by date

  From Date Subject
Next Message Jonathan Rogers 2017-07-21 19:36:37 Re: UPDATE command
Previous Message Graeme Gemmill 2017-07-21 16:24:48 UPDATE command