Port Bug Report: backend closes during transaction

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : A. Van Hook
Your email address : hook(at)kcp(dot)com

Category : unknown
Severity : non-critical

Summary: backend closes during transaction

System Configuration
--------------------
Operating System : redhat 5.2 , Iris5.3

PostgreSQL version : 6.0

Compiler used :

Hardware:
---------
486 32m, Challenge S 160m

Versions of other tools:
------------------------
6.3,6.4

--------------------------------------------------------------------------

Problem Description:
--------------------

insert into assignments (anum,term,cid,chour, wday)
select '1','199804', '201ENG', assignmentcodekey.cd, 'now'
from assignmentcodekey where value = 'Home Work';
PQexec() -- Request was sent to backend, but backend closed the channel before responding.
This probably means the backend terminated abnormally before or while processing the request.

--------------------------------------------------------------------------

Test Case:
----------
sometimes it works

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------