Re: Error creating plpython3u extension

[Jeff Peck <peck.jeff@xxxxxxxxx>]

On 05/08/2018 03:28 PM, Bruce Harold wrote:

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 not load library "C:/Program Files/PostgreSQL/10/lib/plpython3.dll": The specified module could not be found

 

I have conda on the same machine with one Python 3.6 environment, I tried adding a Python 3.4 environment with conda but no luck there either.

 

Anyone have any experience enabling plpython3u in a conda environment?

 

Thanks

 

Bruce

 

 

Hey Bruce,
I suggest that you first check to see if the referenced file exists. If yes, the next step is to go download a tool called Dependency Walker. You will open that dll file in Dependency Walker, and it should tell you if anything required is missing from your box. Most likely you just need to install a specific Visual C++ Runtime Environment. If Dependency Walker lists a DLL like MSVCRXXX.dll in the list, you should be able to search for that and find the correct runtime environment pretty easily.

Good luck,
Jeff Peck