Re: bug: core dump in pl/perl (cvs head).

Michael Fuhr wrote:
> On Tue, Jul 05, 2005 at 04:37:05PM -0400, Tom Lane wrote:
>
>>Michael Fuhr <mike(at)fuhr(dot)org> writes:
>>
>>>On Tue, Jul 05, 2005 at 09:54:52PM +0200, Hans-Jürgen Schönig wrote:
>>>
>>>>we have found a bug in CVS head using PL/Perl:
>>
>>>How current is your checkout? Mine's from this morning and I don't
>>>get a crash with the example you posted:
>>
>>None for me either (trying on a Fedora Core 3 x86 box; don't currently
>>have plperl built on my other machine). Platform-specific issue maybe?
>
>
> My platform that works is Solaris 9/sparc with Perl 5.8.7; compiler
> is gcc 3.4.2.
>
> Did you get a core dump? If so, can you do a stack trace on it?
>

I am running FC4 on x86. There is no core dump.
I have compiled it all over again cleanly.
The last elog is never reached so something seems to go wrong inside the
SQL call ...

CREATE OR REPLACE FUNCTION trig_func() RETURNS trigger AS '
# select the current transaction id
elog(NOTICE, "trigger starting ...");
$sql = "SELECT transaction, pid FROM pg_locks "
. "WHERE transaction IS NOT NULL AND pid =
pg_backend_pid() ";
elog(NOTICE, "sql: $sql");
my $rv = spi_exec_query($sql);
elog(NOTICE, "looking for transactions ...");

I don't know what it is yet as it seemed to work with 8.0.3.
Interesting to see that nodody else has similar problems ...

regards,

hans