Re: Plperl functions not re-entrant, wrong results

[David Fetter <david(at)fetter(dot)org>]

On Mon, Apr 30, 2007 at 12:12:11PM -0400, Kenneth Downs wrote:
> Tom Lane wrote:
> >Kenneth Downs <ken(at)secdat(dot)com> writes:
> >  
> >>Here is a test case to show that plperl functions are not re-entrant.
> >>    
> >
> >I'm very bad in perl, but I think you need to declare all your variables
> >with "my" to make them local instead of global.
> >
> >			regards, tom lane
> 
> Thanks Tom, that did it!  I had one "my" in there, but there was another 
> spot where one was needed.

There's a setting you can set in your postgresql.conf that will help
you find these problems more automatically:

custom_variable_classes = 'plperl'
plperl.use_strict = true

Cheers,
David.
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate