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

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 (view raw or flat)
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

pgsql-novice by date

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

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