Thread: PostgreSQL 7.1.3 hanging problems

I have installed PostgreSQL 7.13 (and cygIPC 1.11) and I am having
problems for executing certain SQL-clauses.
I have an application which generates SQL-clauses dynamically, and I have
noticed that
following clause will for example freeze PostgreSQL.
(I need to stop and start it again in order to get it working again.)
Same clause will work just fine in Oracle with the same tables and data,
so the clause itself should be ok.

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

1) 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

2) 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. Has anybody else noticed similar kind
of problems and
should I try to upgrade my Cygwin to newer version? Where I can I download
the PostgreSQL 7.20 binaries for Cygwin?

Mika

Thanks, I will test the problem again after that!
Can I then just unzip it over the 7.13 in the cygwin-directory?

I know that I need to re-create databases again aftet the upgrade has been
completed.
(In my case I believe that I can just safely delete the directoty
/usr/local/psql/data and re-create database, because
I can easily migrate tables and data again from the Oracle...)

Mika


|---------+---------------------------->
|         |           Jason Tishler    |
|         |           <jason@tishler.ne|
|         |           t>               |
|         |                            |
|         |           11.02.2002 16:23 |
|         |                            |
|---------+---------------------------->

>------------------------------------------------------------------------------------------------------------------------------|
  |
        | 
  |       To:       mika.laitio@sysline.com
        | 
  |       cc:       pgsql-cygwin@postgresql.org
        | 
  |       Subject:  Re: [CYGWIN]
        | 

>------------------------------------------------------------------------------------------------------------------------------|




Mika,

On Mon, Feb 11, 2002 at 01:58:03PM +0200, mika.laitio@sysline.com wrote:
> Where can I btw. download 7.20 binaries for Cygwin?

From a Cygwin mirror, once I upload it.  Sorry, no ETA but you should
not have to wait too long.

Jason

Mika,

On Mon, Feb 11, 2002 at 04:44:14PM +0200, mika.laitio@sysline.com wrote:
> Can I then just unzip it over the 7.13 in the cygwin-directory?

NO!  You should always use Cygwin's setup.exe to install or upgrade a
package.

Jason

> -----Original Message-----
> From: Jason Tishler [mailto:jason@tishler.net]
> Sent: 11 February 2002 15:45
> To: mika.laitio@sysline.com
> Cc: pgsql-cygwin@postgresql.org
> Subject: Re: [CYGWIN] PostgreSQL 7.1.3 hanging problems
>
>
> Mika,
>
> On Mon, Feb 11, 2002 at 04:44:14PM +0200,
> mika.laitio@sysline.com wrote:
> > Can I then just unzip it over the 7.13 in the cygwin-directory?
>
> NO!  You should always use Cygwin's setup.exe to install or
> upgrade a package.

In addition of course, a dump/initdb/reload will be required.

Regards, Dave.