Skip site navigation (1) Skip section navigation (2)

Re: NO DATA error message in Frontend when querying large datasets

From: Jens Kapp <jens-kapp(at)gmx(dot)de>
To: Korry Douglas <korry(dot)douglas(at)enterprisedb(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-odbc(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: NO DATA error message in Frontend when querying large datasets
Date: 2011-01-27 11:14:47
Message-ID: 4D4153A7.9020907@gmx.de (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-odbc
  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
>>>> maestro).
>>>> 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
>>>> data".
>>> 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
>>> time.
>>>
>>> 			regards, tom lane
>>>
>> -- 
>> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-bugs
> -----------------------------------------------------------------------
> 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 InoueDate: 2011-01-27 13:06:56
Subject: Re: ODBC Driver for Windows server 2008
Previous:From: Korry DouglasDate: 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 GuDate: 2011-01-27 12:31:38
Subject: Re: Is there a way to build PostgreSQL client libraries with MinGW
Previous:From: OlegDate: 2011-01-27 11:02:46
Subject: BUG #5852: Function date_trunc is not IMMUTABLE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group