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

Re: wierd error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Travis Hoyt" <thoyt(at)npc(dot)net>
Cc: "Postgres" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: wierd error
Date: 2002-03-07 18:56:50
Message-ID: 12842.1015527410@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"Travis Hoyt" <thoyt(at)npc(dot)net> writes:
>  select * from mydata where to_char(time, 'SS') != '00';
> server sent data ("D" message) without prior row description ("T" message)
> server sent data ("D" message) without prior row description ("T" message)

> Anyone know what this means?  I can do a select count(*) on this and it
> comes back with a value, approx 460k rows.

You're running out of memory for the results on the client side.
libpq is not very graceful about coping with that situation :-(
--- it doesn't crash, but it does forget that it was absorbing
a query result, so then you get all these bogus error messages.
Fixing this is on our TODO list, but it hasn't been very high
priority because in practice you want to avoid such situations in
the first place.

I'd suggest using a cursor to retrieve the huge result a few hundred
rows at a time.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Oliver ElphickDate: 2002-03-07 18:57:27
Subject: Re: wierd error
Previous:From: Al-Haddad, Mohammad JDate: 2002-03-07 16:03:40
Subject: create remote table with sort of index...

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