============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Alessandro Baldoni
Your email address : abaldoni@csr.unibo.it
System Configuration
- ---------------------
Architecture (example: Intel Pentium) : MIPS R10000
Operating System (example: Linux 2.0.26 ELF) : SGI Irix 6.3
PostgreSQL version (example: PostgreSQL-6.4) : PostgreSQL-6.4
Compiler used (example: gcc 2.8.0) : cc 7.1, either with
- -O2 and -g
Please enter a FULL description of your problem:
- ------------------------------------------------
Unable to insert large objects into a table. Sometimes the backend dies,
sometimes it reports it is unable to create
the related xinv or xinx file.
Looking into pgsql/data/base/<tablename> reveals the files have been
created, and they are 16 Kb in size.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
- ----------------------------------------------------------------------
CREATE TABLE FOO (F OID);
INSERT INTO FOO VALUES (lo_import ('foo.ppm'));
If you know how this problem might be fixed, list the solution below:
- ---------------------------------------------------------------------
The debugger (CVD) reports a SIGSEGV at line 1067 of
backend/storage/large_objects/inv_api.c
1066 attptr = ((char *) ntup) + hoff;
1067 *((int32 *) attptr) = obj_desc->offset + nwrite - 1; /*
OFFENDING STATEMENT */
1068 attptr += sizeof(int32);
