Thread: problem with server connection
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.
"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