pgReadData error on simple selects

From: Sam Carter <petrov(at)smithsonite(dot)rice(dot)edu>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: pgReadData error on simple selects
Date: 2000-11-15 22:50:24
Message-ID: Pine.LNX.4.10.10011151640240.26659-100000@smithsonite.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I'm getting the following error message when I try and execute:
'select name from chapter where path ~ 'glacier/$';'

pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.

I changed my code to keep reusing the same PGconn rather than reconnecting
for each query (which is what worked before) as I believe it will be
faster. The above error manifests itself after about the 5th query. I'm
using v1.18 of the Pg library for v5.005_03 of Perl and v.7.0.2 of
Postgresql. I can't find release notes for v7.0.3 to see if this is
addressed (I doubt it) when I look at
http://www.postgresql.org/docs/admin/. I can't find anything in the
Programmers Guide that seems to address this and the web search interface
to the mailing list archives sucks.

any suggestions?

--sam

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2000-11-16 06:32:11 Re: pgReadData error on simple selects
Previous Message Kovacs Zoltan Sandor 2000-11-15 20:38:01 Re: ODBC Maintainer?