From: | iihero <iihero(at)qq(dot)com> |
---|---|
To: | Vincas Dargis <vindrg(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL 8.4 crash on user defined C language function |
Date: | 2012-04-05 14:10:49 |
Message-ID: | tencent_650A4BDE5E1066AD146E5DFC@qq.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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"<vindrg(at)gmail(dot)com>;
Date: Thu, Apr 5, 2012 02:09 PM
To: "iihero"<iihero(at)qq(dot)com>;
Cc: "Merlin Moncure"<mmoncure(at)gmail(dot)com>; "pgsql-general"<pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Guettler | 2012-04-05 14:17:28 | Value to long for type ....: Columnname missing |
Previous Message | Vincent Dautremont | 2012-04-05 14:00:58 | measure time intervals |