2017-04-13 17:19 GMT+02:00 Alvaro Herrera <alvhe...@2ndquadrant.com>:

> Pavel Stehule wrote:
> > Hi
> >
> > When I tested XMLTABLE function I found a bug of XPATH function -
> > xpath_internal
> >
> > There xmltype is not correctly encoded to xmlChar due possible invalid
> > encoding info in header. It is possible when XML was loaded with recv
> > function and has not UTF8 encoding.
> Hmm ... is it possible to create a test that verifies this?  I suppose
> we could have a non-utf8 value as bytea.

I have not any idea. The problem is in utf8 encoded xml with bad header.
There is dependency to database encoding and supported locales.

Maybe I can simulate it with cast without function from bytea to xml - but
it looks more than little bit dirty



> --
> Álvaro Herrera                https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Reply via email to