Re: [HACKERS] query crashes backend - cvs - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] query crashes backend - cvs
Date
Msg-id 199809210129.VAA15270@candle.pha.pa.us
Whole thread Raw
In response to query crashes backend - cvs  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
> interesting that
> select * from work_flats where (METRO_ID = 81 or METRO_ID = 82) and  DISTRICT_ID < 11;
> crashes backend
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally before or while processing the request.
> We have lost the connection to the backend, so further processing is impossible.  Terminating.
> while
> select * from work_flats where METRO_ID = 81 or METRO_ID = 82 and  DISTRICT_ID < 11;
> works ok.
>
> This happens with latest cvs, 6.3.2 has no problem.

I can't reproduce this.  Can you send a reproducable example with data,
or tell me what columns have indexes.

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

pgsql-hackers by date:

Previous
From: Christopher Oliver
Date:
Subject: Re: [sferac@bo.nettuno.it: Re: [HACKERS] BUG: NOT boolfield kills backend]
Next
From: Tom Lane
Date:
Subject: Version numbers (was Re: [PATCHES] Several libpgtcl fixes)