From: George Weaver <gweaver@shaw.ca>
To: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: Working with XML.
Date: Tue, 22 Feb 2005 07:45:46 -0600
Message-ID: <003d01c518e4$d2d7df20$6400a8c0@Dell4500> (raw)
References: <D1444817B78AB546BF2896C2B70E7F04371EF9@ganesh.au.lpint.net>
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 -----
From: Theo Galanakis
To: 'George Weaver'
Cc: 'pgsql-sql@postgresql.org'
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('<?xml version="1.0" encoding="UTF-8"?> <query columns="4" rows="50"><row><cola>774187</cola><colb>222663</colb><colc>2005-02-22 <snip>
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: gweaver@shaw.ca, Theo.Galanakis@lonelyplanet.com.au
Subject: Re: Working with XML.
In-Reply-To: <003d01c518e4$d2d7df20$6400a8c0@Dell4500>
* 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