Home > mailing lists

pgsql backend disconnected - Mailing list pgsql-general

From	nicks.emails
Subject	pgsql backend disconnected
Date	November 1, 1999 07:52:58
Msg-id	000c01bf23c7$31cc4d40$41646464@toshiba7020 Whole thread Raw
List	pgsql-general

Hello,

I not sure if I have got the right person for this but if you could help me it would be extremely helpfull;

The problem is with the following query,

select l.s # p.ss from LSEG_TBL l, LSEG_TBL1 p;

when I try to execute this intersection query the following message is printed to the screen,

pgReadData() --backend closed the channel unexpectedly.

This problem means the backend terminated abnormally

before or while processing the request

We have lost the connection to the backend, so further processing is impossible.

Terminating.

Please could give me some pointers as to where I could look or if necesarry download any patches to fix it.

I am running Redhat 5.2 on an i486-pc-linux-gnu

version of postgres is 6.5.2

version of gcc is 2.7.2.3

Thank you in advance.

From: "Vince DiCiero"
Date: 01 November 1999, 04:29:56
Subject: Performance for case-insensitive queries

From: Geoff Russell
Date: 01 November 1999, 09:23:59
Subject: Untrusted functions on index creation.