query crashes backend - cvs - Mailing list pgsql-hackers

From Oleg Bartunov
Subject query crashes backend - cvs
Date
Msg-id Pine.GSO.3.96.SK.980915234738.15587A-100000@ra
Whole thread Raw
Responses Re: [HACKERS] query crashes backend - cvs  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Re: [HACKERS] query crashes backend - cvs  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] query crashes backend - cvs  (Bruce Momjian <maillist@candle.pha.pa.us>)
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.

    Regards,
        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


pgsql-hackers by date:

Previous
From: Frank Ridderbusch
Date:
Subject: Re: [HACKERS] Found it. Also on SVR4 (Compiling 6.4 on NetBSD...
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Regress results on FreeBSD 2.2.6-RELEASE - RESEND