NO DATA error message in Frontend when querying large datasets

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

Responses

Browse pgsql-bugs by date

  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

Browse pgsql-odbc by date

  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