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

2011-01-27 Thread Jens Kapp
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 - w

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

2011-01-26 Thread 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 sys

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

2011-01-26 Thread Jens Kapp
hi tom, 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 sy

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

2011-01-26 Thread Tom Lane
Jens Kapp 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"

[BUGS] NO DATA error message in Frontend when querying large datasets

2011-01-26 Thread Jens Kapp
hello, 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