Re: [GENERAL] pl/perl problem of memory

2005-03-25 Thread Tom Lane
"GIROIRE Nicolas (COFRAMI)" <[EMAIL PROTECTED]> writes: > In fact, now i put the variable to '' ( $myvar = '' ) but it seems that Perl > don't empty totally memory. See the nearby thread "plperl doesn't release memory". There's some evidence that this may be due to a Perl configuration issue.

Re: [GENERAL] pl/perl problem

2005-03-23 Thread FERREIRA William (COFRAMI)
Title: RE: [GENERAL] pl/perl problem yes, it works exactly what i needed, thanks a lot -Message d'origine- De : Richard Huxton [mailto:dev@archonet.com] Envoyé : mardi 22 mars 2005 12:41 À : FERREIRA William (COFRAMI) Cc : 'Sean Davis'; pgsql-general@postgresql

Re: [GENERAL] pl/perl problem

2005-03-23 Thread FERREIRA William (COFRAMI)
Title: RE: [GENERAL] pl/perl problem thanks a lot with your example and the example of Richard it works fine -Message d'origine- De : Sean Davis [mailto:[EMAIL PROTECTED]] Envoyé : mardi 22 mars 2005 12:51 À : FERREIRA William (COFRAMI) Cc : pgsql-general@postgresql.org Objet

Re: [GENERAL] pl/perl problem

2005-03-22 Thread Sean Davis
On Mar 22, 2005, at 3:13 AM, FERREIRA William (COFRAMI) wrote: my function is very long but i found an example with the same comportment : CREATE OR REPLACE FUNCTION adoc.totoTest()   RETURNS int4 AS $BODY$  my $var = '->>>';  &concat($var);  sub concat {   $var .= 'tagada';  }  elog NOTICE, $var

Re: [GENERAL] pl/perl problem

2005-03-22 Thread Richard Huxton
FERREIRA William (COFRAMI) wrote: my function is very long but i found an example with the same comportment : CREATE OR REPLACE FUNCTION adoc.totoTest() RETURNS int4 AS $BODY$ my $var = '->>>'; &concat($var); sub concat { $var .= 'tagada'; } elog NOTICE, $var; return 4; $BODY$ LANGUAGE

Re: [GENERAL] pl/perl problem

2005-03-22 Thread FERREIRA William (COFRAMI)
essage d'origine-De : Sean Davis [mailto:[EMAIL PROTECTED]Envoyé : lundi 21 mars 2005 16:46À : FERREIRA William (COFRAMI); pgsql-general@postgresql.orgObjet : Re: [GENERAL] pl/perl problem   - Original Message - From: FERREIRA William (COFRAMI) To

Re: [GENERAL] pl/perl problem

2005-03-21 Thread Sean Davis
Title: RE: [GENERAL] Convert Cursor to array   - Original Message - From: FERREIRA William (COFRAMI) To: 'pgsql-general@postgresql.org' Sent: Monday, March 21, 2005 9:22 AM Subject: [GENERAL] pl/perl problem hi   i wrote a store procedure using the pl/pe