From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | replicable problem with PL/Perl |
Date: | 2003-04-19 06:46:46 |
Message-ID: | 200304191216.46925.mallah@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-04-19 06:50:09 | Re: apparent problem with a PL |
Previous Message | Rajesh Kumar Mallah | 2003-04-19 05:59:39 | apparent problem with a PL |