| 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?
| 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 |