X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A6105476128 for ; Sat, 19 Apr 2003 02:48:27 -0400 (EDT) Received: from rtlocal.trade-india.com (unknown [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 861D6476371 for ; Sat, 19 Apr 2003 02:47:35 -0400 (EDT) Received: (qmail 17363 invoked from network); 19 Apr 2003 06:49:50 -0000 Received: from unknown (HELO system67.trade-india-local.com) (unknown) by unknown with SMTP; 19 Apr 2003 06:49:50 -0000 From: Rajesh Kumar Mallah Organization: Infocom Network Limited To: pgsql-sql@postgresql.org Subject: replicable problem with PL/Perl Date: Sat, 19 Apr 2003 12:16:46 +0530 User-Agent: KMail/1.5 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200304191216.46925.mallah@trade-india.com> X-Spam-Status: No, hits=-7.2 required=5.0 tests=BAYES_01,SIGNATURE_SHORT_SPARSE,USER_AGENT version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/297 X-Sequence-Number: 12998 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.