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