OT: PostgreSQL + INTERSECT = problem

Martin 'Goran' Moravec goran na ipp.cas.cz
Úterý Květen 16 11:21:03 CEST 2000


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)

Je to
Postgres 6.5.3-18 

diky za napady
Goran



-- 
                                                                                
                 \||/  
                 |  @___oo
       /\  /\   / (__,,,,| 		
      ) /^\) ^\/ _) 			  
      )   /^\/   _)		 Goran
      )   _ /  / _)                  goran na ipp.cas.cz
  /\  )/\/ ||  | )_)          
 <  >      |(,,) )__) 
  ||      /    \)___)\ 
  | \____(      )___) )___
   \______(_______;;; __;;;


Další informace o konferenci Linux