Re: pl/perl problem

-----Message d'origine-----
De : Sean Davis [mailto:sdavis2@mail.nih.gov]
Envoyé : lundi 21 mars 2005 16:46
À : FERREIRA William (COFRAMI); pgsql-general@postgresql.org
Objet : Re: [GENERAL] pl/perl problem

 

----- 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/perlU language, and the comportment is strange.

my procedure do a select on my database and some traitments too and write the result in a file;

 

when i run the procedure a first time, it works fine, the file is create and data are in. but when i run my procedure a second time, the file is create but the data aren't write in it. where is the problem  ?

 

Can you show the function?

 

 

i had an other problem the past week, but i not able to reproduce it. it was a very simple funtion who store a string into a variable and display it on the screen : something like this :

my $toto = '->';

$toto.='titi';

elog NOTICE, $toto;

 

Again, can you show the whole function?  And do you 'use strict' when coding?