Port Bug Report: backend closes during transaction

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


Your name        : A. Van Hook
Your email address    : hook@kcp.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:
---------


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