[psycopg] Fetching data from binary cursor

Поиск
Список
Период
Сортировка
Искать
От
Tom Kazimiers
Тема
[psycopg] Fetching data from binary cursor
Дата
Msg-id
20170721184920.75hboryinmgdekyw@macberry.localdomain
Список
Дерево обсуждения
[psycopg] Fetching data from binary cursor Tom Kazimiers <tom@voodoo-arts.net>
Re: [psycopg] Fetching data from binary cursor Daniele Varrazzo <daniele.varrazzo@gmail.com>
Re: [psycopg] Fetching data from binary cursor Tom Kazimiers <tom@voodoo-arts.net>
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

В списке psycopg по дате отправления
От: Graeme Gemmill
Дата:
Сообщение: [psycopg] UPDATE command
От: Jonathan Rogers
Дата:
Сообщение: Re: [psycopg] UPDATE command
FAQ