"Matt Magoffin" <[EMAIL PROTECTED]> writes:
> So I explored with a SELECT statement, thinking there was some specific
> XML document causing the crash. I could consistently execute this
> statement to get a crash:

> select XMLSERIALIZE( CONTENT
> (xpath('/als:auto-lead-service/als:[EMAIL PROTECTED]"AREA"][1]/text()', xml,
>               ARRAY[ARRAY['als','http://autoleadservice.com/xml/als']]))[1] 
> as text)
> from lead order by id limit 1 offset 83367;

Could you put together a self-contained example?  It would probably take
someone else a long time to guess at all the details you've left out.

One point in particular is that this query would not use the index
you mentioned, so I doubt that's relevant.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to