From: | Holger Klawitter <holger(at)klawitter(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | backend crashes |
Date: | 1999-09-02 08:21:07 |
Message-ID: | 37CE3373.84A08805@klawitter.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi there,
I am using Linus 2.2.11, PostgreSQL 6.5.1, 128M RAM + 256M Swap.
I am operating on a table "links" with 12 text columns and 5200 rows
(many cells are empty). This folloing select crashes the backend:
select
f.id as orig, t.id as dest
into
"better-az"
from
links f, links t
where
f.id <> t.id and
( f.g <> '' and lower(f.g) = lower(t.g) ) and
f.a = '' and
t.a <> '' and
f.d = t.d
;
The message is:
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing
Terminating.
Is this join just too complex? Or did I trap into a bug?
Regards,
Holger Klawitter
--
Holger Klawitter +49 (0)251 484 0637
holger(at)klawitter(dot)de http://www.klawitter.de/
From | Date | Subject | |
---|---|---|---|
Next Message | Esteban Chiner Sanz | 1999-09-02 08:30:10 | Max function on Timestamp |
Previous Message | Vadim Mikheev | 1999-09-02 01:39:22 | Re: [GENERAL] How to make a read-write atomic? |