I'm trying to work with plpython in postgresql So I run the command:
CREATE EXTENSION plpython3u
but I get the error:
Erro SQL [58P01]: ERROR: could not load library "C:/Program Files/PostgreSQL/15/lib/plpython3.dll": unknown error 126
I read some solutions like this: solution
but none of them helped me. I checked if the DLL exists in the postgres directory, and it is present in the directory
I'm using Windows 11, I have the latest version of Python installed on my computer, and also the environment variables are installed correctly, what could be causing this error? I'm using dbeaver
Edit 1
I followed a Languge package installation toturial from this link: EDB Docs
I also installed the correct version of Python as described in this postgresql document:
C:/ProgramFiles/PostgreSQL/15/doc/installation-notes.html
I added a system/user environment variable called PYTHONHOME% with the path:
C:\edb\languagepack\v3\Python-3.10
but I still get the same error as above.
I also added all the python environment variables (when installing python it already gives the option to install automatically)