Postgres Pro
Downloads
Home   >   mailing lists

Thread:

From
mika.laitio@sysline.com
Date:
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

Re:

From
Jason Tishler
Date:
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

Re:

From
"Rod Taylor"
Date:
psql leaves me one of the attached for the below:

$ psql
Segmentation fault (core dumped)

This works fine:

$ psql -h localhost
Welcome to psql, the PostgreSQL interactive terminal.


$ psql --version
psql (PostgreSQL) 7.2
contains support for: readline, history, multibyte
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996, Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.

--
Rod Taylor

This message represents the official view of the voices in my head

----- Original Message -----
From: "Jason Tishler" <jason@tishler.net>
To: <mika.laitio@sysline.com>
Cc: <pgsql-cygwin@postgresql.org>
Sent: Monday, February 11, 2002 9:23 AM
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
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
>
Attachment

Re:

From
Jason Tishler
Date:
Rod,

On Mon, Feb 11, 2002 at 11:27:53AM -0500, Rod Taylor wrote:
> psql leaves me one of the attached for the below:
>
> $ psql
> Segmentation fault (core dumped)
>
> This works fine:
>
> $ psql -h localhost
> Welcome to psql, the PostgreSQL interactive terminal.

Please search the archives:

    http://archives.postgresql.org/pgsql-cygwin/2002-02/msg00036.php

The fix is in the latest Cygwin snapshot:

    http://cygwin.com/snapshots/

Jason

Re:

From
mika.laitio@sysline.com
Date:
Followup to the PostgreSQL 7.1.3 problem where I could get Postgre to crash
with long SQL-clause. (Always)

7.2 has fixed the problem, YAHOOO!

Mika


|---------+--------------------------------->
|         |           Jason Tishler         |
|         |           <jason@tishler.net>   |
|         |           Sent by:              |
|         |           pgsql-cygwin-owner@pos|
|         |           tgresql.org           |
|         |                                 |
|         |                                 |
|         |           11.02.2002 19:11      |
|         |                                 |
|---------+--------------------------------->

>------------------------------------------------------------------------------------------------------------------------------|
  |
        | 
  |       To:       Rod Taylor <rbt@zort.ca>
        | 
  |       cc:       pgsql-cygwin@postgresql.org
        | 
  |       Subject:  Re: [CYGWIN]
        | 

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




Rod,

On Mon, Feb 11, 2002 at 11:27:53AM -0500, Rod Taylor wrote:
> psql leaves me one of the attached for the below:
>
> $ psql
> Segmentation fault (core dumped)
>
> This works fine:
>
> $ psql -h localhost
> Welcome to psql, the PostgreSQL interactive terminal.

Please search the archives:

    http://archives.postgresql.org/pgsql-cygwin/2002-02/msg00036.php

The fix is in the latest Cygwin snapshot:

    http://cygwin.com/snapshots/

Jason

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org