- Архив списков рассылки pgsql-cygwin
От | mika.laitio@sysline.com |
---|---|
Тема | |
Дата | |
Msg-id | OF425B87B3.8E7D1355-ONC2256B5D.003F92EB@sysline.com обсуждение исходный текст |
Ответы |
Re:
|
Список | pgsql-cygwin |
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
В списке pgsql-cygwin по дате отправления: