Re: Working with XML.

Поиск
Список
Период
Сортировка
От George Weaver
Тема Re: Working with XML.
Дата
Msg-id 003d01c518e4$d2d7df20$6400a8c0@Dell4500
обсуждение исходный текст
Ответ на Working with XML.  (Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>)
Список pgsql-sql
Дерево обсуждения
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>

В списке pgsql-sql по дате отправления: