Re: why can't I load pgxml.sql

my version is 8.3.3:
I found that it's part of the server.
is it said that I should build postgresql with libxml again??


On Mon, 2008-07-28 at 23:00 -0400, Tom Lane wrote:
> Yi Zhao <yi.zhao@alibaba-inc.com> writes:
> > 1. ./configure --with-libxml --with-libxslt
> > 2. make&&make install (successful)
> > 3. test=# \i /usr/local/pgsql/share/contrib/pgxml.sql
>
> > error appearance:
> > SET
> > psql:/usr/local/pgsql/share/contrib/pgxml.sql:10: ERROR:  could not load
> > library "/usr/local/pgsql/lib/pgxml.so": /usr/lib/libxml2.so.2:
> > undefined symbol: gzopen64
>
> Well, you've still failed to mention most all of the relevant
> information, like what platform this is and what PG version.
> But what the above suggests is that libxml2 is linked to a
> version of libz that doesn't appear anywhere in the dynamic
> linker's search path.  How did you obtain or build libxml2,
> exactly?  If this is a Linux platform, I think you might have
> missed out a ldconfig call or two.
>
>             regards, tom lane
>