[REPOST] replicable problem with PL/Perl
От | Rajesh Kumar Mallah |
---|---|
Тема | [REPOST] replicable problem with PL/Perl |
Дата | |
Msg-id | 200304192136.19920.mallah@trade-india.com обсуждение исходный текст |
Список | 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@CompanyId' , xml) from companies where xml is not nulland 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
В списке pgsql-sql по дате отправления: