On Thu, Aug 08, 2019 at 04:30:00PM +0000, Andrew Zimmerman wrote:
> I am getting the following error when importing from a tab-delimited text file longer than 1 GB.
> ERROR: could not stat file "C:\ABC Software\Database Export\Data\invoice_detail.data": Unknown error
> Splitting the tab-delimited file into multiple files less than 1 GB and COPY'ing them individually works correctly.
> I tested on both versions 11.2 and 11.4 on Windows with the same result.
This relates to the fact that Windows does not offer an easy way to
stat() correctly files which are more than 2GB, as the struct stat is
built with a 4-byte size field.