RE: Error creating plpython3u extension

2018-05-09 Thread Bruce Harold
It seems my cheap hack doesn't work, the server connection breaks on CREATE FUNCTION unless PYTHONHOME is set for the system. -Original Message- From: Bruce Harold Sent: Wednesday, May 9, 2018 9:46 AM To: 'Adrian Klaver' ; pgsql-general@lists.postgresql.org Subject: RE:

RE: Error creating plpython3u extension

2018-05-09 Thread Bruce Harold
roperty does not change, the executable is found. Whether or not this works across the server I guess I'll find out shortly, I'm a newbie doing a proof of concept so deployment isn't a concern. Bruce -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.co

Error creating plpython3u extension

2018-05-08 Thread Bruce Harold
Hi I have PostgreSQL 10 on Windows 10 and the EDB language pack X64 for Python 3.4 etc. I edited the system environment variables: PYTHONPATH = C:\edb\languagepack-10\x64\Python-3.4 Added C:\edb\LanguagePack-10\x64\Python-3.4\bin to PATH Creating the extension plpython3u errors: ERROR: could