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

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Susan Cassidy <scassidy(at)stbernard(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: weird empty return from select problem; periodically get no data returned - could it be a network issue?
Date: 2010-07-09 03:08:44
Message-ID: 4C3692BC.7010807@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hiroshi Inoue 2010-07-09 03:31:03 Re: 'default nextval()' loses schema-qualification in dump ?
Previous Message Craig Ringer 2010-07-09 02:53:39 Re: JDBC Postgres problem