On Mon, Apr 30, 2007 at 12:12:11PM -0400, Kenneth Downs wrote: > Tom Lane wrote: > >Kenneth Downs <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings