FAQ
============================================================================
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:
---------


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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 1 | next ›
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedJun 30, '99 at 6:32a
activeJun 30, '99 at 6:32a
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Juman Byun: 1 post

People

Translate

site design / logo © 2022 Grokbase