Hi all

Am I going insane, I've been going around with this for a few hours now,
it could be lack of sleep:)

claimsnet=> select * from roster where state = 'TX' or state = 'SD';
Backend message type 0x44 arrived while idle
Backend message type 0x44 arrived while idle
We have lost the connection to the backend, so further processing is
impossible.  Terminating.
[postgres@laptop ~]$

I can not seem to 'or' any char() field, int4 is OK. I've vacuum'ed with
and with out analyze, I've pg_dumped'ed, destroydb'ed and recreated the
database and reloaded, same thing.

To make matter even crazyer, it only happens with this one database,
others work fine.  AND it is doing this on 2 differant boxes, my laptop
and my server, both Red Hat 4.2 with PostgreSQL 6.4.

I just reloaded new data, so it must be the data, but what about the data
whould do that? Its only 1281 rows, so it's not like it's a lot of data.

I'm going to start splitting up the data and see if I can isolate it.

Thanks
Terry Mackintosh <terry@terrym.com>          http://www.terrym.com
sysadmin/owner  Please! No MIME encoded or HTML mail, unless needed.

Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.4
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!


Sun, 13 Dec 1998 21:57:04 -0500 (EST)
Terry Mackintosh <terry@terrym.com>
Can't 'or' things?
> Hi all
> 
> Am I going insane, I've been going around with this for a few hours now,
> it could be lack of sleep:)
> 
> claimsnet=> select * from roster where state = 'TX' or state = 'SD';
> Backend message type 0x44 arrived while idle
> Backend message type 0x44 arrived while idle
> We have lost the connection to the backend, so further processing is
> impossible.  Terminating.
> [postgres@laptop ~]$
> 
> I can not seem to 'or' any char() field, int4 is OK. I've vacuum'ed with
> and with out analyze, I've pg_dumped'ed, destroydb'ed and recreated the
> database and reloaded, same thing.
> 
> To make matter even crazyer, it only happens with this one database,
> others work fine.  AND it is doing this on 2 differant boxes, my laptop
> and my server, both Red Hat 4.2 with PostgreSQL 6.4.
> 
> I just reloaded new data, so it must be the data, but what about the data
> whould do that? Its only 1281 rows, so it's not like it's a lot of data.
> 
> I'm going to start splitting up the data and see if I can isolate it.

Bug in 6.4.  Fixed in both current trees, and 6.4.1, to be released on
Friday.


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Sun, 13 Dec 1998 22:58:32 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] Can't 'or' things?