From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | terry(at)terrym(dot)com (Terry Mackintosh) |
Cc: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Can't 'or' things? |
Date: | 1998-12-14 03:58:32 |
Message-ID: | 199812140358.WAA06679@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 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(at)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-12-14 04:01:27 | Re: [HACKERS] palloc() vs static define? |
Previous Message | The Hermit Hacker | 1998-12-14 03:54:37 | Please check...ignore them... |