Re: pg_file_settings view vs. Windows

On Sat, Jun 27, 2015 at 07:20:43PM -0400, Tom Lane wrote:
> Tatsuo Ishii <ishii(at)postgresql(dot)org> writes:
> >> I noticed that in EXEC_BACKEND builds (ie, Windows) the pg_file_settings
> >> view doesn't act as its author presumably intended. Specifically, it
> >> reads as empty until/unless the current session processes a SIGHUP event.
>
> > I'm just wondering why we did not catch this earlier. If this is
> > because threre's no regression test case for pg_file_settings view,
>
> Yeah, exactly. Unfortunately I see no way to add a useful test, at least
> not one that will work in installcheck mode. There's no way to predict
> what will be in the view in that case. Even for "make check", the output
> would be pretty darn environment-dependent.

A TAP test case is the way to test this thoroughly. It could feed any number
of specific postgresql.conf variations to a postmaster. See
src/bin/pg_ctl/t/002_status.pl for a test doing something similar. (Granted,
I would not have thought to write such a test for this feature.)