bug en return de funcion?

From: Henry <hensa22(at)yahoo(dot)es>
To: Postgres <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: bug en return de funcion?
Date: 2007-10-27 17:15:06
Message-ID: 714885.88694.qm@web30810.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda


cuando retorno esto en mi funcion de esta manera, el
servidor se cuelga completamente y rechazada todas las
conexiones activas

return cadena1 || ';' || cadena2;

pero si uso esto, todo va normal

var_resultado varchar;
.
.
.
var_resultado=cadena1|| ';' || cadena2;
return var_resultado;

aqui va a el log :

<2007-10-27 11:33:23 > LOG: server process (PID 2604)
exited with exit code -1073741819
<2007-10-27 11:33:23 > LOG: terminating any other
active server processes
<2007-10-27 11:33:23 localhost> WARNING: terminating
connection because of crash of another server process
<2007-10-27 11:33:23 localhost> DETAIL: The
postmaster has commanded this server process to roll
back the current transaction and exit, because another
server process exited abnormally and possibly
corrupted shared memory.
<2007-10-27 11:33:23 localhost> HINT: In a moment you
should be able to reconnect to the database and repeat
your command.
<2007-10-27 11:33:23 localhost> WARNING: terminating
connection because of crash of another server process
<2007-10-27 11:33:23 localhost> DETAIL: The
postmaster has commanded this server process to roll
back the current transaction and exit, because another
server process exited abnormally and possibly
corrupted shared memory.
<2007-10-27 11:33:23 localhost> HINT: In a moment you
should be able to reconnect to the database and repeat
your command.
<2007-10-27 11:33:23 localhost> WARNING: terminating
connection because of crash of another server process
<2007-10-27 11:33:23 localhost> DETAIL: The
postmaster has commanded this server process to roll
back the current transaction and exit, because another
server process exited abnormally and possibly
corrupted shared memory.
<2007-10-27 11:33:23 localhost> HINT: In a moment you
should be able to reconnect to the database and repeat
your command.
<2007-10-27 11:33:23 localhost> WARNING: terminating
connection because of crash of another server process
<2007-10-27 11:33:23 localhost> DETAIL: The
postmaster has commanded this server process to roll
back the current transaction and exit, because another
server process exited abnormally and possibly
corrupted shared memory.
<2007-10-27 11:33:23 localhost> HINT: In a moment you
should be able to reconnect to the database and repeat
your command.
<2007-10-27 11:33:23 localhost> WARNING: terminating
connection because of crash of another server process
<2007-10-27 11:33:23 localhost> DETAIL: The
postmaster has commanded this server process to roll
back the current transaction and exit, because another
server process exited abnormally and possibly
corrupted shared memory.
<2007-10-27 11:33:23 localhost> HINT: In a moment you
should be able to reconnect to the database and repeat
your command.
<2007-10-27 11:33:24 > LOG: all server processes
terminated; reinitializing
<2007-10-27 11:33:25 > LOG: database system was
interrupted at 2007-10-27 10:48:48 Hora est. del
Pacífico de SA
<2007-10-27 11:33:25 > LOG: checkpoint record is at
4/2D876FC0
<2007-10-27 11:33:25 > LOG: redo record is at
4/2D876FC0; undo record is at 0/0; shutdown TRUE
<2007-10-27 11:33:25 > LOG: next transaction ID:
0/732938; next OID: 338208
<2007-10-27 11:33:25 > LOG: next MultiXactId: 1; next
MultiXactOffset: 0
<2007-10-27 11:33:25 > LOG: database system was not
properly shut down; automatic recovery in progress
<2007-10-27 11:33:25 > LOG: redo starts at 4/2D877010
<2007-10-27 11:33:25 > LOG: record with zero length
at 4/2D8984C8
<2007-10-27 11:33:25 > LOG: redo done at 4/2D898498
<2007-10-27 11:33:26 > LOG: database system is ready

Saludos


______________________________________________
Pregunta, Responde, Descubre.
Comparte tus consejos y opiniones con los usuarios de Yahoo! Respuestas
http://es.answers.yahoo.com/info/welcome

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Felipe Amezquita 2007-10-27 17:18:06 could not open process token: error code 5
Previous Message Edwin Perez Lozano 2007-10-27 13:49:22 Re: Equipo con problemas