čt 4. 10. 2018 v 12:18 odesílatel Pavel Stehule <pavel.stehule@gmail.com> napsal:Hičt 4. 10. 2018 v 12:12 odesílatel Sergey Mirvoda <sergey@mirvoda.com> napsal:On Thu, Oct 4, 2018 at 2:11 PM Michael Paquier <michael@paquier.xyz> wrote: If you can, could you please attach this file to this thread? This is important for the archives. -- MichaelLooks like it is too big to send uncompressed, here it is in zip archiveI am try to import this xml to Postgres with pgimportdoc https://github.com/okbob/pgimportdocand looks like some libxml2 issue.pgimportdoc: Unexpected result status: PGRES_FATAL_ERRORpgimportdoc: Error: ERROR: invalid XML contentDETAIL: line 178950: internal error: Huge input lookup� органе Пенсионного фонда Российской Федер ^line 178950: attributes construct errorI checked Sergey's example, and it doesn't crash on Linux - The error is displayed correctly. Looks like MS Windows issue of libxml2postgres=# select xml_is_well_formed(d) from convert_from(pg_read_binary_file('error.xml'),'windows-1251') g(d);┌────────────────────┐│ xml_is_well_formed │╞════════════════════╡│ f │└────────────────────┘(1 row)This issue can be enforced by relatively new libxml2 limitshttps://mail.gnome.org/archives/commits-list/2012-August/msg00645.htmlUnfortunately, default configuration uses xmlParseBalancedChunkMemory for parsing content, and this function cannot to get option like XML_PARSE_HUGESo it is hard to fix it.
Hičt 4. 10. 2018 v 12:12 odesílatel Sergey Mirvoda <sergey@mirvoda.com> napsal:On Thu, Oct 4, 2018 at 2:11 PM Michael Paquier <michael@paquier.xyz> wrote: If you can, could you please attach this file to this thread? This is important for the archives. -- MichaelLooks like it is too big to send uncompressed, here it is in zip archiveI am try to import this xml to Postgres with pgimportdoc https://github.com/okbob/pgimportdocand looks like some libxml2 issue.pgimportdoc: Unexpected result status: PGRES_FATAL_ERRORpgimportdoc: Error: ERROR: invalid XML contentDETAIL: line 178950: internal error: Huge input lookup� органе Пенсионного фонда Российской Федер ^line 178950: attributes construct error
On Thu, Oct 4, 2018 at 2:11 PM Michael Paquier <michael@paquier.xyz> wrote: If you can, could you please attach this file to this thread? This is important for the archives. -- MichaelLooks like it is too big to send uncompressed, here it is in zip archive
If you can, could you please attach this file to this thread? This is important for the archives. -- Michael
XML_PARSE_HUGE
RegardsPavel-- --Regards, Sergey Mirvoda
-- --Regards, Sergey Mirvoda
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных