Re: Postgresql 92 XML gone?

[Andrea Venturoli]

On 08/02/15 13:35, Oliver Heesakkers wrote:

> I believe you also need to
>>
>> create extension xml
>>
>> ?
>
> And databases/postgresql92-contrib

Hello.
Sorry for taking so much time, but I was on holiday.


I added postgresql92-contrib, then issued
# create extension xml;

But I got:
> ERROR: could not open extension control file >: No such file or directory



I looked and in fact there is no
/usr/local/share/postgresql/extension/xml.control, neither in the file
system, nor in the ports plists.

I have xml2.control, though.
However:
> # create extension xml2;
> ERROR: could not load library "/usr/local/lib/postgresql/pgxml.so": dlopen (/usr/local/lib/postgresql/pgxml.so) failed: /usr/local/lib/postgresql/pgxml.so: Undefined symbol "xml_ereport"



Any further hint?

bye & Thanks
av.
_______________________________________________
freebs...@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "freebsd-port...@freebsd.org"

[Christoph Moench-Tegeder]

## Andrea Venturoli (m...@netfence.it):

> I added postgresql92-contrib, then issued
> # create extension xml;

The extension has been renamed to xml2, as you already noticed :)
http://www.postgresql.org/docs/9.2/static/xml2.html
Please mind that there's a built-in xml datatype, and additional
funtions:
http://www.postgresql.org/docs/9.2/static/datatype-xml.html
http://www.postgresql.org/docs/9.2/static/functions-xml.html

Additionally, you're encouraged to use the latest PostgreSQL version,
that is 9.4 these days.

> However:
> > # create extension xml2;
> > ERROR: could not load library "/usr/local/lib/postgresql/pgxml.so": dlopen (/usr/local/lib/postgresql/pgxml.so) failed: /usr/local/lib/postgresql/pgxml.so: Undefined symbol "xml_ereport"

Oh well: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=202649

Please mind that the built-in XML support is (mostly) unavailable
without that patch.

Regards,
Christoph

--
Spare Space

[Andrea Venturoli]

On 08/25/15 12:46, Christoph Moench-Tegeder wrote:

> Additionally, you're encouraged to use the latest PostgreSQL version,
> that is 9.4 these days.

For small not-so-important things, it might not be worth the switch; for
big important things, it might be too much of a trouble to switch light
heartedly.
This decision anyway is not always on me.
Besides, as I read from your link, 9.3 and 9.4 are also affected.

> Oh well: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=202649
>
> Please mind that the built-in XML support is (mostly) unavailable
> without that patch.

Thanks a lot!
This patch solved everything, without requiring contrib or "create
extension"; it just gave me the old behaviour back!


bye
av.