Re: wierd error

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
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:57:27
Message-ID: 1015527447.21923.276.camel@linda
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, 2002-03-07 at 15:27, Travis Hoyt wrote:
> 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)
> 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.

psql has run out of memory.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C

"Go ye therefore, and teach all nations, baptizing them
in the name of the Father, and of the Son, and of the
Holy Ghost; Teaching them to observe all things
whatsoever I have commanded you; and, lo, I am with
you alway, even unto the end of the world. Amen."
Matthew 28:19,20

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jon Hassen 2002-03-07 19:37:37 Re: index item size 4496 exceeds maximum 2713
Previous Message Tom Lane 2002-03-07 18:56:50 Re: wierd error