Was there a bug fix in the COPY command in Version 15?

From: <h-shibata(at)nssys(dot)co(dot)jp>
To: <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Was there a bug fix in the COPY command in Version 15?
Date: 2023-02-01 04:44:30
Message-ID: 20230201044430.00013F8C.0554@nssys.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello.

I had the symptoms when I tried to import a file larger than 2GB with
the COPY command.

# copy A_TABLE from 'C:/A_TABLE.dat' with BINARY;
could not stat file "A_TABLE.dat": Unknown error

Up until PostgreSQL Version 11..14 it was failing in the same way.

But, Up to Version 10, a 2GB file created with `COPY TO` could be copied
with `COPY TO`.
However, in Version 15, I recreated the instance and ran the COPY
command, and it worked.

The command is simple.
> `COPY A_TABLE FROM 'C:/A_TABLE.dat' with BINARY;`

I'm using the Windows version of EDB Binaries.
Did something change in PostgreSQL 15?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2023-02-01 06:38:47 BUG #17766: Issue in asc, limit and offset for pagination.
Previous Message Bowen Shi 2023-02-01 02:47:32 Re: BUG #17744: Fail Assert while recoverying from pg_basebackup