X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 57D7A8B9CC8 for ; Tue, 22 Feb 2005 13:46:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66140-06 for ; Tue, 22 Feb 2005 13:45:50 +0000 (GMT) Received: from pd6mo3no.prod.shaw.ca (idcmail-mo2no.cg.shawcable.net [64.59.134.9]) by svr1.postgresql.org (Postfix) with ESMTP id 2FEF08B9CB7 for ; Tue, 22 Feb 2005 13:45:52 +0000 (GMT) Received: from pd7mr6no.prod.shaw.ca (pd7mr6no-qfe2.prod.shaw.ca [10.0.144.223]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0ICB00ID8FKD0490@l-daemon> for pgsql-sql@postgresql.org; Tue, 22 Feb 2005 06:45:49 -0700 (MST) Received: from pn7ml4no.prod.shaw.ca ([10.0.149.113]) by pd7mr6no.prod.shaw.ca (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0ICB00CMYFKDT700@pd7mr6no.prod.shaw.ca> for pgsql-sql@postgresql.org; Tue, 22 Feb 2005 06:45:49 -0700 (MST) Received: from Dell4500 (S01060004236fc1f7.wp.shawcable.net [24.77.13.13]) by l-daemon (iPlanet Messaging Server 5.2 HotFix 1.18 (built Jul 28 2003)) with SMTP id <0ICB00A6KFK9MP@l-daemon> for pgsql-sql@postgresql.org; Tue, 22 Feb 2005 06:45:49 -0700 (MST) Date: Tue, 22 Feb 2005 07:45:46 -0600 From: George Weaver Subject: Re: Working with XML. To: Theo Galanakis Cc: pgsql-sql@postgresql.org Message-id: <003d01c518e4$d2d7df20$6400a8c0@Dell4500> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Mailer: Microsoft Outlook Express 6.00.2900.2180 Content-type: multipart/alternative; boundary="----=_NextPart_000_003A_01C518B2.8549AA90" X-Priority: 3 X-MSMail-priority: Normal References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.527 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO, HTML_60_70, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200502/241 X-Sequence-Number: 20352 This is a multi-part message in MIME format. ------=_NextPart_000_003A_01C518B2.8549AA90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MessageHi Theo, I am not able to duplicate the problem you experienced. I tried the = query you provided below using pgAdmin and psql on a 7.3.2 and an 8.0 = database with success. I then copied all the rows and pasted them to = the end so that I would have 100 rows, and the query worked as expected. Perhaps the client you're using is causing the problem. Can you run the = query in pgAdmin? Regards, George ----- Original Message -----=20 From: Theo Galanakis=20 To: 'George Weaver'=20 Cc: 'pgsql-sql@postgresql.org'=20 Sent: Monday, February 21, 2005 11:54 PM Subject: RE: [SQL] Working with XML. Thankyou George, XML2 compiled ok... next stummbling block.. when I pass a very long = XML string to xpath_string() it crashes the postgres server. Client = receives a message like: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Below is the function call, a smaller xml string with say 40 records = works fine, anything bigger crashes the server. select xpath_string(' 7741872226632005-02-22 = ------=_NextPart_000_003A_01C518B2.8549AA90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message
Hi Theo,
 
I am not able to duplicate the problem = you=20 experienced.  I tried the query you provided below using = pgAdmin and=20 psql on a 7.3.2 and an 8.0 database with success.  I then copied = all the=20 rows and pasted them to the end so that I would have 100 rows, and=20 the query worked as expected.
 
Perhaps the client you're using is = causing the=20 problem.  Can you run the query in pgAdmin?
 
Regards,
George
----- Original Message -----
From:=20 Theo Galanakis =
Sent: Monday, February 21, 2005 = 11:54=20 PM
Subject: RE: [SQL] Working with = XML.

Thankyou George,
 
XML2=20 compiled ok... next stummbling block..  when I pass a very = long XML=20 string to xpath_string() it crashes the postgres server. Client = receives=20 a message like:
 
server closed the connection = unexpectedly
This=20 probably means the server terminated abnormally
before or while = processing=20 the request.
 
Below is the function call, a smaller xml = string with=20 say 40 records works fine, anything bigger crashes the=20 server.
 
select = xpath_string('<?xml=20 version=3D"1.0" encoding=3D"UTF-8"?> <query columns=3D"4"=20 = rows=3D"50"><row><cola>774187</cola><colb>2226= 63</colb><colc>2005-02-22=20 <snip>
------=_NextPart_000_003A_01C518B2.8549AA90--