Michael Fuhr wrote:
> On Tue, Jul 05, 2005 at 04:37:05PM -0400, Tom Lane wrote:
>
>>Michael Fuhr <mike@fuhr.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
transactionIS NOT NULL AND pid =
pg_backend_pid() "; elog(NOTICE, "sql: $sql"); my $rv = spi_exec_query($sql); elog(NOTICE,
"lookingfor 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