I have installed PostgreSQL 7.1.3 (and cygIPC 1.11) and I am having
problems with long SQL-clauses.
I have an application which generates SQL-clauses dynamically, and then for
example following clause will freeze PostgreSQL
and I need to stop and start it again in order to get it working again.
(Same clause will work just fine in Oracle)
select distinct project_dim.c_id, project_fact.c_id from project_dim,
project_fact, time_dim where
project_fact.c_project_dim_c_id=project_dim.c_id and
project_fact.c_time_dim_c_id
in (select time_dim.c_id from time_dim where time_dim.c_time in (select
max(time_dim.c_time)
from time_dim where project_fact.c_project_dim_c_id=project_dim.c_id and
project_fact.c_time_dim_c_id=time_dim.c_id))
The error-message I get to pgAdmin II is:
"An error has occured in pgAdmin II: frmSQLInput.cmdExecute_Click"
Number: -2147467259
Description: Error while executing the query; No response from the backend;
Error while reading the socket."
If I split the SQL-clause to two separated clauses like
Select distinct project_dim.c_id, project_fact.c_id from project_dim,
project_fact, time_dim where
project_fact.c_project_dim_c_id=project_dim.c_id and
project_fact.c_time_dim_c_id
in (select time_dim.c_id from time_dim)
and
select max(time_dim.c_time)
from time_dim where project_fact.c_project_dim_c_id=project_dim.c_id and
project_fact.c_time_dim_c_id=time_dim.c_id
Then everythinh will work just fine. Should I try to upgrade my Cygwin to
newer one (About 1 month old installation) and/or PostgreSQL to 7.20?
Where can I btw. download 7.20 binaries for Cygwin?
Mika