Bug reference: 15942
Logged by: Michal C
Email address: [hidden email] PostgreSQL version: 11.4
Operating system: Microsoft Windows [Version 10.0.18362.267]
Sorry my English is horribile.
my PG version is "PostgreSQL 11.4, compiled by Visual C++ build 1914,
I create 2 GB file:
from generate_series(1,1024*1024*2,1) d(number))
and reading information about file:
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;
and result is:
> ERROR: could not stat file "my_data_01.txt": Unknown error
> SQL state: XX000
When I run the script on PG 10.9 on the same computer, everything works
but that hasn't been turned into a patch and you shouldn't
hold your breath waiting for it to happen :-(. There's probably
no chance that the eventual fix would be safe to back-patch into
existing release branches, either.
So ... we might have a fix for this someday, but probably not soon.
It is annoying that we're just reporting "Unknown error" though.
That could be improved to show something more specific without
a lot of work, I imagine.