Port Bug Report: Unable to write/import large objects - Mailing list pgsql-ports

From Unprivileged user
Subject Port Bug Report: Unable to write/import large objects
Date
Msg-id d333e4fbb8bdfadd9cd93c5b30a8fc91
Whole thread Raw
List pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : Matt Seaborn
Your email address    : Matthew.Seaborn@brunel.ac.uk

Category        : runtime: back-end
Severity        : critical

Summary: Unable to write/import large objects

System Configuration
- --------------------
  Operating System   : SunOS 5.5.1

  PostgreSQL version : 6.4

  Compiler used      : gcc

Hardware:
- ---------


Versions of other tools:
- ------------------------


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

Problem Description:
- --------------------
Whenever an attempt to create a large object is made, be it
via SQL or LIBPQ it errors and drops out with the error

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.


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

Test Case:
- ----------
create table lo (name text, raster oid);
insert into lo (name, raster) values ('image', lo_import('/etc/motd'));

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

Solution:
- ---------


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

pgsql-ports by date:

Previous
From: Marcin Jackowski
Date:
Subject: PGSQL 6.4 - problem
Next
From: Unprivileged user
Date:
Subject: Port Bug Report: pqReadData() -- backend closed the channel unexpectedly.