Re: PostgreSQL 8.4 crash on user defined C language function

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

Browse pgsql-general by date

  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