my PG version: PostgreSQL 13.1, compiled by Visual C++ build 1914, 64-bit
from generate_series(1,1024*1024*2,1) d(number)) to 'C:\Program
with files as (select * from pg_ls_dir('.') f(file) where file ilike
, files_info as (select file, (pg_stat_file(file)).* from files)
select * from files_info;
Result is: could not stat file "my_data_01.txt": Unknown error
Re: BUG #16813: error to solve the problem "Windows could not stat file - over 4GB"
On Thu, Jan 07, 2021 at 02:02:06PM +0000, PG Bug reporting form wrote:
> my PG version: PostgreSQL 13.1, compiled by Visual C++ build 1914, 64-bit
> testing method
> select * from files_info;
> Result is: could not stat file "my_data_01.txt": Unknown error
bed9075 will be available in PG14. We may consider a backpatch but
I'd rather have more dust settle on what has been committed on HEAD
before doing such a move (as known as wait for 14 to be released at
least in beta to get this code tested more extensively in the field).
Or are you saying that you tested the patch on top of some 13 code and
it did not work?