"Matt Magoffin" <postgresql.org@xxxxxxx> 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:meta[@key="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
