Re: BUG #15858: could not stat file - over 4GB

From: Emil Iggland <emil(at)iggland(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: Juanjo Santamaria Flecha <juanjo(dot)santamaria(at)gmail(dot)com>
Subject: Re: BUG #15858: could not stat file - over 4GB
Date: 2020-02-05 11:46:33
Message-ID: 158090319335.731.5370958126217783154.pgcf@coridan.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

The following review has been posted through the commitfest application:
make installcheck-world: not tested
Implements feature: tested, passed
Spec compliant: not tested
Documentation: not tested

I ran into this problem when using psql.exe and copy command.

I have checked out 11.6-release tarball and applied the patch.
The patch does not apply cleanly, but can be easily modified to apply. See Note 1.
After applying the patch I built using "build psql" and ran the new psql.exe binary.

In order to test I have done the following:
Against a PostgreSQL 11 server run two commands:
"COPY public.table FROM 'C:/file'" and "\copy public.table FROM 'C:/file'"
The first one runs in the context of the server, and does not work. It aborts with an error saying "cannot stat file", as expected.
The seconds on runs in the context of the new binary and does work. It copies data as expected.

Note 1:
src/tools/msvc/Mkvcbuild.pm should be

- sprompt.c strerror.c tar.c thread.c getopt.c getopt_long.c dirent.c
- win32env.c win32error.c win32security.c win32setlocale.c);
+ sprompt.c tar.c thread.c getopt.c getopt_long.c dirent.c
+ win32env.c win32error.c win32security.c win32setlocale.c win32_stat.c);

The new status of this patch is: Waiting on Author

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephen Frost 2020-02-05 12:07:12 Re: BUG #16234: LDAP Query
Previous Message Thomas Butz 2020-02-05 11:06:41 Re: BUG #16241: Degraded hash join performance

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2020-02-05 12:51:13 Re: [HACKERS] advanced partition matching algorithm for partition-wise join
Previous Message Masahiko Sawada 2020-02-05 11:26:27 Identifying user-created objects