Re: How can I configure the postgresql odbc to return 1 row

You can use in the odbc.ini configuration the following
definitions:

Fetch = 2048
UseDeclareFetch = 1

"Fetch" defines the number of rows to fetch at a time.
UseDeclareFetch activates the feature.

Regards,
Marko Ristola

Jeff Eckermann wrote:

>--- Jerry Lam <jlam@sandvine.com> wrote:
>
>
>>Hi,
>>
>>Is it possible to ask postgresql odbc driver to
>>fetch the resulsets from the table one at a time
>>instead of fetching all millions rows into memory?
>>
>>
>
>Perhaps setting the "Use declare/fetch" driver option
>to true will help you.  This will cause a server side
>cursor to be used, which will return the rows in
>blocks.  What controls the size of the blocks, I have
>no idea; I've never messed with that.
>
>
>
>>Thank you,
>>
>>Jerry
>>
>>---------------------------(end of
>>broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>               http://www.postgresql.org/docs/faq
>>
>>
>>
>
>
>
>__________________________________
>Do you Yahoo!?
>Yahoo! Small Business - Try our new resources site!
>http://smallbusiness.yahoo.com/resources/
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>
>