============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Tatiana Savenkova
Your email address : tis@relcom.ru
Category : runtime: back-end
Severity : serious
Summary: pqReadData() -- backend closed the channel unexpectedly.
System Configuration
- --------------------
Operating System : FreeBsd 3.0-RELEASE
PostgreSQL version : 6.4
Compiler used : gcc v2.7
Hardware:
- ---------
Timecounter "i8254" frequency 1193182 Hz cost 3031 ns
Timecounter "TSC" frequency 400911248 Hz cost 124 ns
CPU: Pentium II (quarter-micron) (400.91-MHz 686-class CPU)
Origin = "GenuineIntel" Id = 0x651 Stepping=1
Features=0x183fbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CM
OV,PAT,PSE36,MMX,<b24>>
real memory = 134217728 (131072K bytes)
avail memory = 128069632 (125068K bytes)
Versions of other tools:
- ------------------------
gmake version 3.76.1
flex version 2.5.4
- --------------------------------------------------------------------------
Problem Description:
- --------------------
When I create index on <classname>(att_name)
and then do
select with OR'ed this att_name
I get fatal error.
Example of my query:
bismap=> SELECT DISTINCT ind FROM terpro WHERE (prod_code
bismap-> LIKE '0750453%' OR prod_code LIKE '0867%');
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally before or while pr
ocessing the request.
We have lost the connection to the backend, so further processing is impossible.
Terminating.
- -------------------
Att_name prod_code char(11) was indexed by:
create index tpprod on terpro(prod_code);
If I do select without OR i.e.
bismap=> SELECT DISTINCT ind FROM terpro WHERE (prod_code
bismap-> LIKE '0750453%');
everything is OK.
How to resolve this problem?
- --------------------------------------------------------------------------
Test Case:
- ----------
- --------------------------------------------------------------------------
Solution:
- ---------
- --------------------------------------------------------------------------
