Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL
Date: 2023-09-08 11:07:58
Message-ID: 63b173c8-03fe-5238-8060-434ea9f8822e@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/7/23 23:51, Sai Teja wrote:
> Thank you so much for all your responses.
>
> I just tried with Hash, GIN etc
>
> But it didn't worked. And I think it is because of "Xpath" expression
> which I used in the index create command.
>
> But is there any alternative way to change this Xpath? Since I need to
> parse the XML as there is no other option. I need the other ways to
> create the index .
>
> May be if there are any parameters to change like xmloption etc it
> would help us to resolve the issue.
>
> Thanks,
> Sai
>
>

What is a typical value returned by your xpath statement? (XPATH
(‘directory/access/mode/@Identifier’, content))

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nature Conservation Geovista Space 2023-09-08 11:25:26 Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
Previous Message duc hiep ha 2023-09-08 10:19:01 Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?