If possible, could you use a compiled version of PG8.4, and debug your code via attaching the server process. Thus you can get more details why it crashed in your codeline. ------------------ Original ------------------ From: "Vincas Dargis"<vin...@gmail.com>; Date: Thu, Apr 5, 2012 02:09 PM To: "iihero"<iih...@qq.com>; Cc: "Merlin Moncure"<mmonc...@gmail.com>; "pgsql-general"<pgsql-general@postgresql.org>; Subject: Re: [GENERAL] PostgreSQL 8.4 crash on user defined C language function
Yeah, original example took command from arguments, I simply forgot to revert changes to original. Though it's not the problem, it is something with calling other functions under some kind environment I got. Your test was successful for "obviously it should work" reason, but it's something wrong for me that server crashes before executing "INFO 5"... 2012.04.05 02:38, iihero ra??: > Hi, > > In your code, only the last line "pfree(command);" is wrong. No need to > put it there. Since you use the constant string for the variable command. > > In my test, > > here is the result: > > iihero=# select test(); > INFO: 1 > INFO: 2 > INFO: 3 > INFO: 4 > INFO: 5 > INFO: 6 > INFO: 7 > INFO: EXECQ: 1 > test > ------ > > (1 row) > > > ------------------ > ~~~~~~~~~~~~~~~~~~~~~~~~~ > iihero > http://www.sql9.com > http://www.sql6.com > ~~~~~~~~~~~~~~~~~~~~~~~~~ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
