Re: Inconsistent query results...

Okay... so I tried putting a test query "select 1" in front of the given query
and that fails also....

> Problem is, after using pg_numrows to determine how many rows were selected,
it > returns 0 about 5-10% of the time.  Weird, isn't it?  When this happens the
> PHP script will return an error stating "hostname could not be resolved", as
> it should.

Basically one of the postgres backends was failing to work properly (or php
messed up the persistant connection...  ?) ... with 6 http processes ~15%
failure makes sense.

A restart of the http server fixed it ... for now.  I am still sort of
wondering on this event though... its not very nice behavior.  Maybe I will
have to schedule regular http restarts.

-Andy