Re: [HACKERS] query crashes backend - cvs - Mailing 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.        |