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
