Re: Help with plpython3u

On 6/9/20 5:09 PM, PEDRO PABLO SEVERIN HONORATO wrote:
> Hello!
> 
> I'm cracking my head while trying to make python language work within 
> postges. I executed "*create extension plpython3u*" but I get this error:
> 
> "*ERROR: could not load library "C:/Program 
> Files/PostgreSQL/12/lib/plpython3.dll": The specified module could not 
> be found. SQL state: 58P01*"
> 
> Looking into several stackoverflow pages and asking like everywhere, I 
> also installed dependency walker and saw that python37.dll was required. 
> My PC already has python 3.7.4, but I don't know if that is an issue and 
> postgres requires python 3.7.0 strictly.
> 
> I also copied the python37.dll file directly in the System32 folder, as 
> some pages suggested. That actually made it possible to run the 
> "* create extension plpython3u* ", but when I try to create a simple 
> function like:
> 
> "*CREATE FUNCTION pymax (a integer, b integer)*
> *  RETURNS integer
> AS $$
>    if a > b:
>      return a
>    return b
> *
> *$$ LANGUAGE plpython3u*;"
> 
> The server crashes and I get this message: "*Connection to the server 
> has been lost*."
> 
> Some additional information:
> - My PC is running windows server 2019 64 bits (its a vps)

How did you install Postgres?

> - The python version I have is 3.7.4. Installed it with Anaconda

Unless things have changed since the last time I used Anaconda, it 
basically creates virtualenvs for it's installs. So when you refer to 
the Python dll above are you talking about a system installed one or one 
from within the Anaconda environment?

> - Postgres version is 12.2-1. pgAdmin is 4.18
> 
> Please, help me :(
> Regards,
> PS


-- 
Adrian Klaver
adrian.klaver@aklaver.com