thanks a lot, "Declare/Fetch" fixed our issue!
Am 27.01.2011 00:36, schrieb Korry Douglas:
>> thanks a lot for your response.
>> the frontend we are trying to use is a well known and spread laboratory system. our consultant has experience with other databases (oracle, sql) that are a lot bigger - with no problems. however i'm wondering that postgres is not working with the lab system AND other common DB frontends using ODBC. i guess there is no setting for: "use cursor instead" ?
> "Use Declare/Fetch" may be the setting that you want. That's a setting in the ODBC driver and you should be able to change that setting through the Windows ODBC Administrator.
> You may also want to change the "Server side prepare" setting. (Be sure to change one setting at a time and test your application between changes).
> -- Korry
>> Am 26.01.2011 20:16, schrieb Tom Lane:
>>> Jens Kapp<jens-kapp(at)gmx(dot)de> writes:
>>>> we have postgres 9.0.1 installed on a windows 2008 r2 server.
>>>> odbc is psqlodbc_09_00_0200.zip.
>>>> the database has currently a size of around 800mb.
>>>> it works as expected on the server (pgadmin), but if we try queries for
>>>> large datasets we get the error message: "No data" from our frontend or
>>>> any other database tools thats using the ODBC connection (e.g. anysql
>>>> 1.) first we will make a query with only 1 column. we get data.
>>>> 2.) then make the same query but with all columns: it says "No data".
>>>> 3.) Afterwards we try the query from before again, but still getting "No
>>> I wonder whether you're running out of memory for the query result in
>>> the client side, and this "no data" is coming from some code that is not
>>> written to cope with that happening.
>>> You might consider using a cursor to fetch large results a few rows at a
>>> regards, tom lane
>> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
>> To make changes to your subscription:
> Korry Douglas
> Senior Database Dude
> EnterpriseDB Corporation
> The Enterprise Postgres Company
> Phone: (804)241-4301
> Mobile: (620) EDB-NERD
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Inoue||Date: 2011-01-27 13:06:56|
|Subject: Re: ODBC Driver for Windows server 2008|
|Previous:||From: Korry Douglas||Date: 2011-01-26 23:36:13|
|Subject: Re: NO DATA error message in Frontend when querying large datasets|
pgsql-bugs by date
|Next:||From: Xiaobo Gu||Date: 2011-01-27 12:31:38|
|Subject: Re: Is there a way to build PostgreSQL client libraries
|Previous:||From: Oleg||Date: 2011-01-27 11:02:46|
|Subject: BUG #5852: Function date_trunc is not IMMUTABLE|