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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jens Kapp <jens-kapp(at)gmx(dot)de>
Cc: 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-26 19:16:18
Message-ID: 23282.1296069378@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-odbc
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

In response to

Responses

pgsql-odbc by date

Next:From: Jens KappDate: 2011-01-26 22:39:25
Subject: Re: NO DATA error message in Frontend when querying large datasets
Previous:From: Jens KappDate: 2011-01-26 16:17:51
Subject: NO DATA error message in Frontend when querying large datasets

pgsql-bugs by date

Next:From: Josh BerkusDate: 2011-01-26 19:43:22
Subject: Re: Multicolun index creation never completes on 9.0.1/solaris
Previous:From: Tom LaneDate: 2011-01-26 19:10:17
Subject: Re: Multicolun index creation never completes on 9.0.1/solaris

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