Re: [GENERAL] why can't I load pgxml.sql

2008-07-28 Thread Klint Gore
Yi Zhao wrote: 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?? googling gzopen64 throws up a whole lot of hits - most of them were debian/ubuntu and boiled down to some problem with versions of libz.so klint. -- Klint

Re: [GENERAL] why can't I load pgxml.sql

2008-07-28 Thread Tom Lane
Yi Zhao <[EMAIL PROTECTED]> writes: > my version is 8.3.3: I kinda doubt that, actually, because you should not have been getting "function not found" errors in 8.3. An 8.3 server built without XML support should react more like this: regression=# select xpath('foo','bar'); ERROR: unsupported X

Re: [GENERAL] why can't I load pgxml.sql

2008-07-28 Thread Yi Zhao
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 <[EMAIL PROTECTED]> writes: > > 1. ./configure --with-libxml --with-libxslt > > 2. make&&make install (successful)

Re: [GENERAL] why can't I load pgxml.sql

2008-07-28 Thread Tom Lane
Yi Zhao <[EMAIL PROTECTED]> 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/

[GENERAL] why can't I load pgxml.sql

2008-07-28 Thread Yi Zhao
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: undefi