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 ------------------
Date: Thu, Apr 5, 2012 02:09 PM
To: "iihero"<iihero@xxxxxx>;
Cc: "Merlin Moncure"<mmoncure@xxxxxxxxx>; "pgsql-general"<pgsql-general@xxxxxxxxxxxxxx>;
Subject: Re: [GENERAL] PostgreSQL 8.4 crash on user defined C language function
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general