i have never seen this before ...
after rebooting the box (for some other reason) it worked.
somehow there has been something else going terribly wrong ...
sorry for the confusion ...
best regards,
hans
Hans-Jürgen Schönig wrote:
> 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 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
