Thread: Port Bug Report: Large object importing fails from backend

Port Bug Report: Large object importing fails from backend

From
Unprivileged user
Date:
============================================================================
                        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:
---------


--------------------------------------------------------------------------