============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Juman Byun
Your email address : olbyun@academy.hanyang.ac.kr
Category : runtime: back-end
Severity : serious
Summary: Large object importing fails from backend
System Configuration
--------------------
Operating System : Sparc Solaris 2.6
PostgreSQL version : 6.4.2
Compiler used : gcc 2.8.1
Hardware:
---------
Ultra Sparc 256MB RAM
Versions of other tools:
------------------------
all GNU tools
--------------------------------------------------------------------------
Problem Description:
--------------------
built-on function lo_import() fails
the file to be ol_import()ed is world readable like this.
-rw-r--r-- 1 root sys 52 Jan 1 1970 /etc/motd
i typed the lo example postgresql manual in this homepage.
--------------------------------------------------------------------------
Test Case:
----------
i got the error below.
CREATE TABLE image (
name text,
raster oid
);
INSERT INTO image (name, raster)
VALUES ('beautiful image', lo_import('/etc/motd'));
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.
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------