BUG #15654: COPY command not working for 2gb CSV files

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: sandeep(dot)t(dot)kumar(at)gmail(dot)com
Subject: BUG #15654: COPY command not working for 2gb CSV files
Date: 2019-02-25 11:03:51
Message-ID: [email protected]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15654
Logged by: Sandeep Kumar
Email address: sandeep(dot)t(dot)kumar(at)gmail(dot)com
PostgreSQL version: 11.0
Operating system: Windows
Description:

Hi Team,

When i am trying to import the data from CSV file of 2 GB , getting
following error and i have observed that the file size of less then 2 GB
went well without any issue.Please look into this and provide your inputs on
this.

Command I am using
-----------------------------
Copy table From '<Filename>.csv' DELIMITER '~' null as 'null' encoding
'windows-1251' CSV; select 1;

Error I am getting
------------------------
ERROR: could not stat file "<Filename>.csv": Unknown error
SQL state: XX000

Thanks
Sandeep

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Prakash Ramakrishnan 2019-02-25 11:45:28 Re: BUG #15648: oracle_fdw extension not able to create
Previous Message Hans Buschmann 2019-02-25 10:59:48 AW: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x