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(at)odt(dot)east(dot)telecom(dot)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(at)localhost postgres]$ /usr/local/pgsql/bin/postmaster --version
postmaster (PostgreSQL) 7.4.2
[postgres(at)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