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