replicable problem with PL/Perl

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.

Responses

Browse pgsql-sql by date

  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