Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-es-ayuda by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group