|
Hi
George,
I sent out a message shortly after this that didn't get
through. However it's good news, I rebooted the server and it appears to work
fine now. Thankyou for all your help, appreciated!!
Theo
-----Original Message-----
From:
George Weaver [mailto:[EMAIL PROTECTED]
Sent: Thursday, 24 February
2005 2:00 AM
To: Theo Galanakis
Cc:
pgsql-sql@postgresql.org
Subject: Re: [SQL] Working with
XML.
Hi 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 -----
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:[EMAIL PROTECTED]
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 -----
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.
|
|
