RES: 8.2.4 selects make applications wait indefinitely

From: "Carlos H(dot) Reimer" <carlos(dot)reimer(at)opendb(dot)com(dot)br>
To: "Erik Jones" <erik(at)myemma(dot)com>
Cc: "Pgsql-General(at)Postgresql(dot)Org" <pgsql-general(at)postgresql(dot)org>
Subject: RES: 8.2.4 selects make applications wait indefinitely
Date: 2007-10-11 11:40:58
Message-ID: PEEPKDFEHHEMKBBFPOOKKEGCFKAA.carlos.reimer@opendb.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Erik,

> Are all of these remote connections from the same machine? Did you
> upgrade your client postgres libraries on your remote machine(s) as
> well?

No, the problem happens with many machines where our Visual Basic
applications is running. After debuging the application we discovered that
the problem was always with "select *" statements. We started then some
tests to understand what was happening. This tests were done using the psql
utility from a Windows Postgresql 8.2.4 server against the SUSE PG 8.2.4
production server. Using this Windows server we make all the other tests
against the SUSE PG 8.2.4 production server.

Reimer

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2007-10-11 12:07:55 Invalid error message when user has nologin attibute
Previous Message Carlos H. Reimer 2007-10-11 11:33:12 RES: 8.2.4 selects make applications wait indefinitely