Skip site navigation (1) Skip section navigation (2)

BUG #1159: server closed the connection unexpectedly

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1159: server closed the connection unexpectedly
Date: 2004-05-31 08:09:39
Message-ID: 20040531080939.7A02ECF525D@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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



Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-05-31 16:55:21
Subject: Re: BUG #1159: server closed the connection unexpectedly
Previous:From: Werner BohlDate: 2004-05-31 06:06:28
Subject: Re: BUG #1158: tsearch2 trigger crashes machine

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group