OT: PostgreSQL + INTERSECT = problem

[Petr Cech]

Martin 'Goran' Moravec napsal:
> Mam zajivavy problem, u $subj, pokud zadam slozitejsi dotaz, (i na postgresove kozoli) backend spadne, je-li v nem INTERSECT, neco jako SELECT+"300 znaku podminek"+INTERSECT + libovolne maly select. a dostavam hlasku:
> 
> 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.
> 
> Dotaz je syntakticky spravne, v logu postgresu bylo jen toto:
> /*debug_level=2*/
> 
> /usr/lib/postgresql/bin/postmaster: reaping dead processes...
> /usr/lib/postgresql/bin/postmaster: CleanupProc: pid 11913 exited with status 11/usr/lib/postgresql/bin/postmaster: CleanupProc: reinitializing shared memory and semaphores
> shmem_exit(0) [#0]
> binding ShmemCreate(key=52e451, size=2006016)

signal 11 - sigsegv :( Chyba v programu.

> Je to
> Postgres 6.5.3-18 

skoda ze uz neni zabalena i 7.0 (bez beta). Upgrade je v pohode, ale nevim,
jak se bude chovat upgrade na 7.0 final z 7.0beta5, protoze je potreba
dumpnout databazi a zaroven si schovat stary server na provedeni upgradu.

				Petr Cech
-- 
Debian GNU/Linux maintainer - www.debian.{org,cz}
           cech na atrey.karlin.mff.cuni.cz

* Joy sees a potato running down the street and shouting "I'm late! I'm late!" ;))