Re: should i need to install xml library in postgresql inorder to work on xml file?

On Mon, 2008-07-28 at 18:36 +0100, Raymond O'Donnell wrote:
> On 28/07/2008 17:25, aravind chandu wrote:
>
> >             I installed postgresql on my sytem,I need to parse an xml
> > file.When I am working on xpath() it is showing an error that function
> > is notfound and i tried almost all xml functions in postgresql but it is
> > giving me the same result.why so ? should I have to install any xml
> > library inorder to avoid this?Please tell me its very important for me.
>
> A five-second scan of the docs reveals the following:
>
> "Use of many of these functions requires the installation to have been
> built with configure --with-libxml."[1]
>
> Are you in a position to see whether this was done on your installation?

Running pg_config will give him the info.

Joshua D. Drake

>
> Ray.
>
> [1] http://www.postgresql.org/docs/8.3/static/functions-xml.html
>
>
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod@iol.ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate