Re: [HACKERS] Bug on complex join

Hello!
  Another symptom. The query

SELECT cn.date_i, cn.pos_id                                                        FROM central cn
                                             WHERE cn.date_i >= current_date - '300 days'::timespan


returns 3156 rows. But this:

SELECT cn.date_i, p.subsec_id, cn.pos_id, p.pos_id  FROM central cn, shops sh, districts d, positions p     WHERE
cn.date_i>= current_date - '300 days'::timespan
 

failed:

pqReadData() -- backend closed the channel unexpectedly.This probably means the backend terminated abnormally before or
whileprocessing the request.
 
We have lost the connection to the backend, so further processing is impossible.  Terminating.
  Tables attached (ZIP file with script to recreate tables and SQL
commands).

Oleg.
----    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net          Programmers don't die, they
justGOSUB without RETURN.