Re: BUG #15942: not working function pg_stat_file - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15942: not working function pg_stat_file
Date
Msg-id 22988.1565214270@sss.pgh.pa.us
Whole thread Raw
In response to BUG #15942: not working function pg_stat_file  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> I create 2 GB file:
> ...
> (and then pg_stat_file fails on it)

Yeah, this is a known problem on Windows: it provides a stat() function
that fails on large files.  There's been some discussion of how we might
work around that, most recently here:
https://www.postgresql.org/message-id/flat/1803D792815FC24D871C00D17AE95905CF5099%40g01jpexmbkw24

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.

            regards, tom lane



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15942: not working function pg_stat_file
Next
From: PG Bug reporting form
Date:
Subject: BUG #15943: Valgrind-detected error in SlruPhysicalWritePage