[REPOST] replicable problem with PL/Perl

Hi this strage phenomenon is happening with my PL/Perl
if one  pl/perl function raises an ERROR even other pl/perl
functions stop working and keep rasing the previous error

Regds
Mallah.

tradein_clients=# UPDATE companies set xml = utils.print_file('/usr/local/perlapache/htdocs/templates/hp/data/company_'
||company_id || '.xml');
 
UPDATE 713
tradein_clients=#
tradein_clients=# UPDATE companies set xml = utils.print_file('/usr/local/perlapache/htdocs/templates/hp/data/company_'
||company_id || '.xml');
 
UPDATE 713
tradein_clients=# SELECT company_id, utils.pgxml_xpath_pl('/Company@CompanyId' , xml) from companies where xml is not
nulland company_id=619;
 
INFO:  pgxml_xpath_pl called

ERROR:  There was an error:
mismatched tag at line 45, column 867, byte 2849 at /opt/perl/lib/site_perl/5.8.0/i686-linux/XML/Parser.pm line 185

tradein_clients=# UPDATE companies set xml = utils.print_file('/usr/local/perlapache/htdocs/templates/hp/data/company_'
||company_id || '.xml');
 
ERROR:  plperl: error from function:
mismatched tag at line 45, column 867, byte 2849 at /opt/perl/lib/site_perl/5.8.0/i686-linux/XML/Parser.pm line 185

This query was working previously and utils.print_file is independent of utils.pgxml_xpath_pl


tradein_clients=#


-- 
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org