Install numpy to use within plpython3u in postgres 9.6 for Windows 2012 (64 bit)

[PeterS <postgres@xxxxxxxxxxxx>]

I am trying to install numpy to use within plpython3u in postgres 9.6 for Windows 2012 (64 bit) but I run into dependency problems.

1) I have installed Postgres 9.6 from EnterpriseDB and the language pack, which installs Python 3.3.  <- is there a way to install a newer version of Python?

I have done CREATE EXTENSION plpython3u; and it works correctly.

I tried to install python modules with:   pip3.exe install numpy   and   python -m pip install --user numpy   but numpy-1.12.1 returns an error: raise RuntimeError("Python version 2.7 or >= 3.4 required.")

If I try to install an older version of numpy==1.10.4, there are a number of errors about blas and atlas and fortran compilers not being available - so I didn't pursue that avenue much further.

2) If I install Python 3.6 separately, when CREATing EXTENSION plpython3u, I get the ERROR:  could not load library "C:/Program Files/PostgreSQL/9.6/lib/plpython3.dll": The specified module could not be found.
The DLL *is* in that location, but the utility "depends" shows that it is compiled for python33 and not python36, and those dependencies are missing.  Could I replace the plpython3.dll file somehow to get it to work with Python 3.6?


Surely someone has installed numpy for plpython3u in postgres for Windows, but I could not find any solutions so far, so I'm reaching out to the experts.

Thanks

Peter