============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Roman V. Isaev
Your email address : rm@techno.ru
Category : runtime: back-end
Severity : critical
Summary: PL/pgSQL crashes on the BSDI platform
System Configuration
--------------------
Operating System : bsdi bsd/os 3.1
PostgreSQL version : 6.5.1
Compiler used : gcc version 2.7.2.1
Hardware:
---------
p133, 32 meg ram
BSD/OS skylink.ru 3.1 BSDI BSD/OS 3.1 Kernel #0:
Thu Dec 11 13:42:37 MSK/MSD 1997 sysadm@c1.techno.ru:/usr/src/sys/compile/MY i386
Versions of other tools:
------------------------
GNU Make version 3.75, lex version 2.5.3
--------------------------------------------------------------------------
Problem Description:
--------------------
create function test() returns int4 as ' begin return 0; end;' language 'plpgsql';
CREATE
select test();
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is impossible. Terminating.
plpgsql regression test does not work too. it did not work in bsdi 2.1, did not work in 3.1, did not work in 4.0. also
because of the closed backend:
QUERY: insert into Room values ('105', 'Office');
QUERY: insert into Room values ('106', 'Office');
QUERY: insert into WSlot values ('WS.001.1a', '001', '', '');
! pqReadData() -- backend closed the channel unexpectedly.
! This probably means the backend terminated abnormally
! before or while processing the request.
! We have lost the connection to the backend, so further processing i
s impossible. Terminating.
--------------------------------------------------------------------------
Test Case:
----------
compile and install 6.5 or 6.5.1 on BSDI BSD/OS box
run
create simple function and try to call it
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------