On Thu, Nov 18, 2004 at 04:37:42PM -0500, Tom Lane wrote:
> Got it ...
Excellent -- I get no crashes with the test cases. Thanks.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of broadcast)---
TIP 8: explain analyze is your friend
John Hansen <[EMAIL PROTECTED]> writes:
> The following function:
> ...
> creashes the backend, UNLESS it's executed in the same session where it was
> created.
Got it ...
RCS file: /cvsroot/pgsql/src/pl/plperl/plperl.c,v
***
*** 659,665
--- 655,664
int
I've come up with a simpler test case:
CREATE OR REPLACE FUNCTION foo(INTEGER) RETURNS INTEGER AS $$
my @a = 1..$_[0];
elog INFO, "array has $_[0] elements";
return $_[0];
$$ LANGUAGE plperl;
Here's the Solaris 9 failure mode:
test=> select foo(131); -- works consistently
INFO: a
On Wed, Nov 17, 2004 at 02:49:15PM +1100, John Hansen wrote:
> The following function:
[snip]
> creashes the backend, UNLESS it's executed in the same session where it was
> created.
I can reproduce this crash on the following platform:
Solaris 9
PostgreSQL 8.0.0beta4 (CVS)
Perl 5.8.5
g
The following function:
create function text_to_words(text)
returns setof text as $_$
my %stopwords = ( 'i' => 'i','me' => 'me','my' => 'my','myself' =>
'myself','we' => 'we','our' => 'our','ours' => 'ours','ourselves' =>
'ourselves','you' => 'you','your' => 'your','yours' => 'yours','yourse
