[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(at)CompanyId' , xml) from companies where xml is not null and 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