Thread: problem with server connection

problem with server connection

From
"Sidar Lopez Cruz"
Date:
i do this query: select c.cedula,t.nombre.t.id_tipo_documento from c left join tmp t on c.cedula=t.cedula;
 
and the server says
 
Server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request
 
The connection to the server was lost. Attempting reset: Failed
 
what's happen????
 
i am working on the server, with Mandrake 9.1, PostgreSQL 7.3.2

:-) Sidar Lopez Cruz
- Cero Riesgo, S.A.

Re: problem with server connection

From
Tom Lane
Date:
"Sidar Lopez Cruz" <sidarlopez@hotmail.com> writes:
> i do this query: select c.cedula,t.nombre.t.id_tipo_documento from c left j=
> oin tmp t on c.cedula=3Dt.cedula;

> and the server says

> Server closed the connection unexpectedly

We're going to need more info than that.  What shows up in the
postmaster's log (stderr or syslog output)?  Can you get a stack trace
from the crashed backend?  (If there's no core file in the database
subdirectory, try restarting the postmaster with "ulimit -c unlimited"
before trying again.)

            regards, tom lane