Re: SELECT (sometimes) returning Zero Rows?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matt Friedman" <matt(at)sprynewmedia(dot)com>
Cc: "PgSql General List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: SELECT (sometimes) returning Zero Rows?
Date: 2001-02-13 23:46:26
Message-ID: 11929.982107986@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Matt Friedman" <matt(at)daart(dot)ca> writes:
> We are having what seems like a baffling problem to me.
> On occasion, our SELECTs will return zero rows when we know with certainty
> that they should be returning at least some rows. No error occurs, the
> select just behaves as if the db is empty or something.

What PG version is this? What does EXPLAIN show for the misbehaving
queries?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2001-02-13 23:51:39 PostgreSQL non-FAQ documentation
Previous Message Tom Lane 2001-02-13 23:32:36 Re: psql segfault