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.