From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: pgsql-sql@postgresql.org
Subject: replicable problem with PL/Perl
Date: Sat, 19 Apr 2003 12:16:46 +0530
Message-ID: <200304191216.46925.mallah@trade-india.com> (raw)
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 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com
Subject: Re: replicable problem with PL/Perl
In-Reply-To: <200304191216.46925.mallah@trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox