NO DATA error message in Frontend when querying large datasets
| От | Jens Kapp |
|---|---|
| Тема | NO DATA error message in Frontend when querying large datasets |
| Дата | |
| Msg-id | 4D40492F.2070108@gmx.de обсуждение исходный текст |
| Ответы |
Re: NO DATA error message in Frontend when querying large datasets
|
| Список | pgsql-bugs |
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 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". Only a reconnect will "fix" that! here are the results: select sample_number from result Query OK, 325194 rows affected (28.75 sec) select * from result Query OK, 0 rows affected (8.75 sec) select sample_number from result Query OK, 0 rows affected (0.20 sec) cheers jk
В списке pgsql-bugs по дате отправления: