Hi,
just updated development version from cvs and got strange problem :
select * from WORK_FLATS where DISTRICT_ID in (4,101);
select * from WORK_FLATS where DISTRICT_ID in (101,4);
Does anyone understand what's the difference between this two selects ?
explain produces the same plans:
Index Scan using wfidx_district_id on work_flats (cost=6.90 size=29 width=132)
but first select works fine while second fails with message:
flats=> select * from WORK_FLATS where DISTRICT_ID in (101,4);
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.
6.3.2+patches works ok !!!
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
