Re: COPY command returns "ERROR: invalid XML content"

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: Konstantin Izmailov <pgfizm(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY command returns "ERROR: invalid XML content"
Date: 2019-10-07 12:13:46
Message-ID: 20191007121346.4pgmw4edqkdj3jps@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Oct 06, 2019 at 08:45:40PM -0700, Konstantin Izmailov wrote:
>Hi,
>I'm using libpq (v10) to import lots of xml files into a PG10 table. I
>noticed if number of records imported exceeds 2100 then the following error
>is returned:
>ERROR: invalid XML content
>DETAIL: line 1: Couldn't find end of Start Tag
>timeBasedFileNamingAndTriggerin line 1
>logFile.%d{yyyy-MM-dd}.%i.html</fileNamePattern><timeBasedFileNamingAndTriggerin
>

My guess is this is an issue/limitation in libxml2, which we use to
parse and process XML. What libxml2 version you have installed? Can you
share an example of a XML document to reproduce the issue?

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2019-10-07 12:19:06 Re: Install postgres on rhel 7
Previous Message Andres Freund 2019-10-07 09:27:22 Re: RowDescription message