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 Regards Pavel > > -- > Álvaro Herrera https://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services >