pgsql: Fix fstat() emulation on Windows with standard streams

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix fstat() emulation on Windows with standard streams
Date: 2021-11-25 03:17:59
Message-ID: E1mq5Gp-0002vn-2o@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix fstat() emulation on Windows with standard streams

The emulation of fstat() in win32stat.c caused two issues with the
existing in-core callers, failing on EINVAL when using a stream as
argument:
- psql's \copy would crash when using a stream.
- pg_recvlogical would fail with -f -.

The tests in copyselect.sql from the main test suite covers the first
case, and there is a TAP test for the second case. However, in both
cases, as the standard streams are always redirected, automated tests
did not notice those issues, requiring a terminal on Windows to be
reproducible.

This issue has been introduced in bed9075, and the origin of the problem
is that GetFileInformationByHandle() does not work directly on streams,
so this commit adds an extra code path to emulate and return a set of
stats that match best with the reality. Note that redirected streams
rely on handles that can be queried with GetFileInformationByHandle(),
but we can rely on GetFinalPathNameByHandleA() to detect this case.

Author: Dmitry Koval, Juan José Santamaría Flecha
Discussion: https://postgr.es/m/17288-6b58a91025a8a8a3@postgresql.org
Backpatch-through: 14

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/d2198b4593cca21390907a1d6762e3a0357298db

Modified Files
--------------
src/port/win32stat.c | 20 ++++++++++++++++++++
1 file changed, 20 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2021-11-25 06:06:36 pgsql: Block ALTER TABLE .. DROP NOT NULL on columns in replica identit
Previous Message Andres Freund 2021-11-25 01:01:45 Re: pgsql: xlog.c: Remove global variables ReadRecPtr and EndRecPtr.