From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | oleg(at)sai(dot)msu(dot)su (Oleg Bartunov) |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] query crashes backend - cvs |
Date: | 1998-09-21 01:29:42 |
Message-ID: | 199809210129.VAA15270@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)candle(dot)pha(dot)pa(dot)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. |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-09-21 01:34:33 | Re: [HACKERS] Transaction system (proposal for 6.5) |
Previous Message | Christopher Oliver | 1998-09-21 00:54:00 | Re: [sferac@bo.nettuno.it: Re: [HACKERS] BUG: NOT boolfield kills backend] |