Re: weird empty return from select problem; periodically get no data returned - could it be a network issue? - Mailing list pgsql-general

From Craig Ringer
Subject Re: weird empty return from select problem; periodically get no data returned - could it be a network issue?
Date
Msg-id 4C3692BC.7010807@postnewspapers.com.au
Whole thread Raw
In response to weird empty return from select problem; periodically get no data returned - could it be a network issue?  (Susan Cassidy <scassidy@stbernard.com>)
List pgsql-general
On 9/07/2010 2:58 AM, Susan Cassidy wrote:

> This is a pg cluster installation, using version 8.3.5.

"Pg cluster"?

There are quite a few different clustering setups for Pg.

Do you mean PgCluster from http://pgfoundry.org/projects/pgcluster/ ? If
so, which version and how is it set up?

Or some other Pg-based cluster using Bucardo, Slony-II, etc?


As for your issue: have you excluded the possibility that there is no
data to return? Issues sometimes arise where the data you're expecting
to retrieve hasn't been committed by another transaction yet, so it's in
the database but not yet visible. As you haven't provided your queries
or schema it's hard to know what's going on there.

--
Craig Ringer

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: JDBC Postgres problem
Next
From: Thomas Kellerer
Date:
Subject: How to download Non-Installer (ZIP) Postgres 8.3 for Windows?