Re: Error creating plpython3u extension

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