BUG #15975: Copy from large text files on Windows returns "iso-8859-1 error"

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15975: Copy from large text files on Windows returns "iso-8859-1 error"
Дата
Msg-id 15975-80e6438a9a73f74f@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15975: Copy from large text files on Windows returns "iso-8859-1 error"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15975
Logged by:          Johann Oskarsson
Email address:      johann@myrkraverk.com
PostgreSQL version: 11.5
Operating system:   Windows 10
Description:

When I try to load a large text file into PostgreSQL 11 on Windows, I get an
"unknown error."  This has been discussed on StackOverflow here:
https://stackoverflow.com/q/53523051/264751

It turns out that trying to COPY FROM a large textfile, say several
gigabytes, will always fail.  According to Stack Overflow, this only happens
on PostgreSQL 11.  The earlier releases don't seem to have this problem.

Example, given

  create table pwned( passwd sha1 not null, count int4 not null );

Then

  copy pwned( passwd, count ) from
'c:\src\postgres\pwned\pwned-passwords-sha1-ordered-by-hash-v5.txt' with (
format text, delimiter ':' );

gives

  ERROR:  could not stat file
"c:\src\postgres\pwned\pwned-passwords-sha1-ordered-by-hash-v5.txt": Unknown
error

Workaround is to pipe the file through a program, as discussed here:
https://wp.me/p4w9PF-di


В списке pgsql-bugs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #15974: Concact with || doesn't work, but function CONCAT () works
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15858: could not stat file - over 4GB