BUG #1159: server closed the connection unexpectedly

The following bug has been logged online:

Bug reference:      1159
Logged by:          Ilya S. Slyzhnyak

Email address:      ilya@odt.east.telecom.kz

PostgreSQL version: 7.4

Operating system:   Linux

Description:        server closed the connection unexpectedly

Details:

Server closes connection, PostgreSQL 7.3.2 have same problem:
[postgres@localhost postgres]$ /usr/local/pgsql/bin/postmaster --version
postmaster (PostgreSQL) 7.4.2
[postgres@localhost postgres]$ /usr/local/pgsql/bin/psql -e -f test.sql test
CREATE TABLE inventory (
    invnum character(8) NOT NULL,
    description character(255)
);
CREATE TABLE
CREATE FUNCTION get_inventory(text) RETURNS inventory
    AS 'SELECT * FROM inventory WHERE invnum = $1;'
    LANGUAGE sql;
CREATE FUNCTION
CREATE TABLE test (
    inv inventory
);
CREATE TABLE
CREATE FUNCTION get_description(inventory) RETURNS character
    AS 'SELECT $1.description;'
    LANGUAGE sql;
CREATE FUNCTION
INSERT INTO inventory (invnum, description) VALUES (13172801, 'aaa');
INSERT 66300 1
INSERT INTO inventory (invnum, description) VALUES (13172802, 'bbb');
INSERT 66301 1
INSERT INTO test (inv) VALUES (get_inventory(13172801));
INSERT 66302 1
INSERT INTO test (inv) VALUES (get_inventory(13172802));
INSERT 66303 1
SELECT get_description(inv) FROM test;
psql:test.sql:24: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
psql:test.sql:24: connection to server was lost