backend crashing with INTERSECT / ORDER BY

From: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
To: pgsql-general(at)hub(dot)org
Subject: backend crashing with INTERSECT / ORDER BY
Date: 1999-08-20 13:24:32
Message-ID: 14269.22288.701528.749251@blanc.aeccom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


So I tried INTERSECT with ORDER BY and it crashes on 6.5 and 6.5.1:

[csmaster(at)kamet release0]$ psql cs1
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: cs1

cs1=> SELECT envelope FROM docobj
cs1-> WHERE attrid=5
cs1-> INTERSECT
cs1-> SELECT envelope FROM docobj
cs1-> WHERE attrid=6
cs1-> ORDER BY attrid DESC
cs1-> ;
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 is impossible. Terminating.

Any clues?

Dirk

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ralli 1999-08-20 13:50:43 unsubscribe
Previous Message Henrique Pantarotto 1999-08-20 12:44:40 Re: [GENERAL] Trigger documentation? Need more examples.. pleeeze.. ; -)