pl/perl function life and variable scope - concurrency problem?
От | Christopher Murtagh |
---|---|
Тема | pl/perl function life and variable scope - concurrency problem? |
Дата | |
Msg-id | 1068667533.879.105.camel@mafalda.murtagh.name обсуждение исходный текст |
Ответы |
Re: pl/perl function life and variable scope - concurrency problem?
|
Список | pgsql-general |
Greetings, Thanks to a lot of help on this list, I've managed to get my pl/perl function working. However, I have an unexpected result. Here's a simple way to reproduce this problem: CREATE or REPLACE FUNCTION perltest(integer) returns integer as ' $MyInt = $MyInt + 1; return $MyInt; ' language plperlu; Executing it produces: chris=# select perltest(1); perltest ---------- 1 (1 row) chris=# select perltest(1); perltest ---------- 2 (1 row) chris=# select perltest(1); perltest ---------- 3 (1 row) chris=# select perltest(1); perltest ---------- 4 (1 row) Doing the right thing and initialzing variables before using them solves this. Should I worry about this? Are concurrent callings of this function protected from each other? Any info would be much appreciated. Cheers, Chris -- Christopher Murtagh Enterprise Systems Administrator ISR / Web Communications Group McGill University Montreal, Quebec Canada Tel.: (514) 398-3122 Fax: (514) 398-2017
В списке pgsql-general по дате отправления: