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: Wed, 23 Feb 2005 08:59:56 -0600
Message-ID: <006e01c519b8$591396a0$6400a8c0@Dell4500> (raw)
References: <D1444817B78AB546BF2896C2B70E7F04371EFA@ganesh.au.lpint.net>
MessageHi Theo,
Hmm. Well we're getting into territory that's over my head. I've simply been a user of xml2 and do not know much about its inner workings. Just out of curiosity, what is the size of Sort_Mem in your postgresql.conf?
Regards,
George
----- Original Message -----
From: Theo Galanakis
To: 'George Weaver'
Cc: 'pgsql-sql@postgresql.org'
Sent: Tuesday, February 22, 2005 4:13 PM
Subject: Re: [SQL] Working with XML.
George,
I have run this SP in Cold Fusion, PgAdmin and EMS PostgreSQL Manager 2, with all the same results. We are currently using Redhat ES3 and Postgres 7.4.5.
Theo
-----Original Message-----
From: George Weaver [mailto:gweaver@shaw.ca]
Sent: Wednesday, 23 February 2005 12:46 AM
To: Theo Galanakis
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Working with XML.
Hi 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>
______________________________________________________________________
This email, including attachments, is intended only for the addressee
and may be confidential, privileged and subject to copyright. If you
have received this email in error, please advise the sender and delete
it. If you are not the intended recipient of this email, you must not
use, copy or disclose its content to anyone. You must not copy or
communicate to others content that is confidential or subject to
copyright, unless you have the consent of the content owner.
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: <006e01c519b8$591396a0$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