pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

pgReadData error on simple selects
2+ messages / 2 participants
[nested] [flat]

* pgReadData error on simple selects
@ 2000-11-15 22:50  Sam Carter <petrov@smithsonite.rice.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: Sam Carter @ 2000-11-15 22:50 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: pgReadData error on simple selects
@ 2000-11-16 06:32  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Sam Carter <petrov@smithsonite.rice.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2000-11-16 06:32 UTC (permalink / raw)
  To: Sam Carter <petrov@smithsonite.rice.edu>; +Cc: pgsql-interfaces

Sam Carter <petrov@smithsonite.rice.edu> writes:
> 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.

A stack trace from the backend's core file would be useful here ...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2000-11-16 06:32 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-15 22:50 pgReadData error on simple selects Sam Carter <petrov@smithsonite.rice.edu>
2000-11-16 06:32 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox