[unixODBC-support] Problem in using cursor to fetchmillionsofrows

Jerry Lam jlam at sandvine.com
Thu Apr 7 15:09:00 BST 2005


Here is the list of the packages installed in my freebsd machine. This morning I'm thinking of going from the other direction. I'm wondering if there is something that I can turn on/off postgresql to fetch one row at a time. However I browse through a lot of web sites, it doesn't seem there is a configuration option for that. Unless it is permanently turn off in the postgresqlodbc driver. 

apache+mod_ssl-1.3.33+2.8.22 The Apache 1.3 webserver with SSL/TLS functionality
bash-2.05b.007      The GNU Bourne Again Shell
bash-completion-20031112 Programmable completion library for Bash 2.04 and up
expat-1.95.6_1      XML 1.0 parser written in C
freevrrpd-0.8.7_1   This a VRRP RFC2338 Compliant implementation under FreeBSD
gettext-0.12.1      GNU gettext package
gnupg-1.2.3_4       The GNU Privacy Guard
htmldoc-1.8.23      Converts HTML to PDF and/or PostScript
latprobe-BSD-1.02.0003 Active latency probe
libgnugetopt-1.2    GNU getopt library
libiconv-1.9.1_3    A character set conversion library
licenseSigner-BSD-1.00.0066 Sandvine License Signer
mm-1.3.1            Shared memory allocation library for pre-forked process mod
net-snmp-5.21.0056  An extendable SNMP implementation
openssl-0.9.7c      SSL and crypto library
pamd-BSD-2.01.0001  Pluggable Authentication Module Daemon
postgresql-7.4.6_0_001 The most advanced open-source database available anywhere
postgresql-unixodbc-07.03.0200_010 PostgreSQL ODBC client support
rc_subr-1.31        Common startup and shutdown subroutines used by scripts
socket-1.1          Create tcp socket and connect to stdin/out
sudo-  Allow others to run commands as root
syslog-ng-1.6.0.r4  A powerfull syslogd replacement
tclkit-BSD-2.09.0005 Tool Control Language and packages
unixODBC-2.2.7_005  ODBC library suite for Unix
vim-lite-6.1.48     Vi "workalike", with many additional features


-----Original Message-----
From: unixodbc-support-bounces at easysoft.com
[mailto:unixodbc-support-bounces at easysoft.com]On Behalf Of Nick Gorham
Sent: Thursday, April 07, 2005 1:46 AM
To: Eric Sharkey; Support for the unixODBC project
Subject: Re: [unixODBC-support] Problem in using cursor to

Eric Sharkey wrote:

>>It behaves exactly the same, ~129M. I just purely run isql with the
>>select statement inside isql interative mode.
>So it isn't a problem with tcl.
>As I was saying earlier, this may be normal behavior for the driver.
>I don't know much about the postgresql driver.  You may find more
>knowledgable people on the pgsql-odbc at postgresql.org mailing list.
>unixODBC-support mailing list
>unixODBC-support at easysoft.com
What postgres driver are you using?

I have never seen this with the PG drivers I have used.

unixODBC-support mailing list
unixODBC-support at easysoft.com

More information about the unixODBC-support mailing list