Re: BUG #15975: Copy from large text files on Windows returns "unknown error"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: johann(at)myrkraverk(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15975: Copy from large text files on Windows returns "unknown error"
Date: 2019-08-23 21:53:56
Message-ID: 19689.1566597236@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> It turns out that trying to COPY FROM a large textfile, say several
> gigabytes, will always fail.

This is being worked on. If you're in a position to review or test
the patch being discussed here:

https://commitfest.postgresql.org/24/2189/

please do.

> According to Stack Overflow, this only happens
> on PostgreSQL 11.

Seems unlikely. There's never been support in PG for working around
Windows' weirdness in this area (ie lack of stat() support for the case).

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2019-08-24 02:23:19 Re: BUG #15964: vacuumdb.c:187:10: error: use of undeclared identifier 'FD_SETSIZE'
Previous Message Tom Lane 2019-08-23 21:49:20 Re: BUG #15858: could not stat file - over 4GB