From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
cc: pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Prevent infinity and NaN in jsonb/plperl transform
In-reply-to: <E1fDCX9-0005yu-7q@gemulon.postgresql.org>
References: <E1fDCX9-0005yu-7q@gemulon.postgresql.org>
Comments: In-reply-to Peter Eisentraut <peter_e@gmx.net>
	message dated "Mon, 30 Apr 2018 17:24:15 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <21193.1525110966.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 30 Apr 2018 13:56:06 -0400
Message-ID: <21194.1525110966@sss.pgh.pa.us>
Precedence: bulk

Peter Eisentraut <peter_e@gmx.net> writes:
> Prevent infinity and NaN in jsonb/plperl transform

So this isn't working on Windows:

contrib/jsonb_plperl/jsonb_plperl.c(226): warning C4013: 'isnan' undefined=
; assuming extern returning int [c:\pgbuildfarm\pgbuildroot\HEAD\pgsql.bui=
ld\jsonb_plperl.vcxproj]
...
.\Release\jsonb_plperl\jsonb_plperl.dll : fatal error LNK1120: 1 unresolve=
d externals [c:\pgbuildfarm\pgbuildroot\HEAD\pgsql.build\jsonb_plperl.vcxp=
roj]

The reason seems to be this kluge in plperl.h:

/* stop perl headers from hijacking stdio and other stuff on Windows */
#ifdef WIN32
#define WIN32IO_IS_STDIO
/*
 * isnan is defined in both the perl and mingw headers. We don't use it,
 * so this just clears up the compile warning.
 */
#ifdef isnan
#undef isnan
#endif
#endif							/* WIN32 */

Looks like the half-life of that hack just expired.  What shall
we do about it?

If you don't have an immediate solution, please revert this commit
temporarily, as it's preventing me from making any further progress
on the reattach-failure investigation.

			regards, tom lane