From: | Jens Kapp <jens-kapp(at)gmx(dot)de> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org |
Subject: | NO DATA error message in Frontend when querying large datasets |
Date: | 2011-01-26 16:17:51 |
Message-ID: | 4D40492F.2070108@gmx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-01-26 17:21:52 | Re: BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore |
Previous Message | Radu Ilie | 2011-01-26 13:49:21 | BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-01-26 19:16:18 | Re: NO DATA error message in Frontend when querying large datasets |
Previous Message | Mathias Zajaczkowski | 2011-01-25 16:03:07 | ODBC Driver for Windows server 2008 |