From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | c_michal(at)poczta(dot)onet(dot)pl |
Subject: | BUG #15942: not working function pg_stat_file |
Date: | 2019-08-07 20:07:27 |
Message-ID: | 15942-58fbac022aa82a2f@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15942
Logged by: Michal C
Email address: c_michal(at)poczta(dot)onet(dot)pl
PostgreSQL version: 11.4
Operating system: Microsoft Windows [Version 10.0.18362.267]
Description:
Sorry my English is horribile.
my PG version is "PostgreSQL 11.4, compiled by Visual C++ build 1914,
64-bit"
I create 2 GB file:
show data_directory;
Result: "D:/pg_data"
copy (select
to_char(number,'0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000')
from generate_series(1,1024*1024*2,1) d(number))
to 'D:\pg_data\my_data_01.txt';
and reading information about file:
with files as (select * from pg_ls_dir('.') f(file) where file ilike
'my_data_01.txt')
, 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
fine.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-08-07 21:44:30 | Re: BUG #15942: not working function pg_stat_file |
Previous Message | Tom Lane | 2019-08-07 15:16:08 | Re: BUG #15941: Query does not return |