I am trying to write a function in PostgreSQL on Windows with a Python script in the body, and I am running an error message when I try to create the plpythonu extension. The command that I run:
CREATE EXTENSION plpythonu;
Which causes the following error message:
ERROR: could not access file "$libdir/plpython2": No such file or directory
SQL state: 58P01
I also tried to run:
CREATE EXTENSION plpython3u;
leading to this error:
ERROR: could not load library "C:/Program Files (x86)/PostgreSQL/9.2/lib/plpython3.dll": The specified module could not be found.
SQL state: 58P01
The plpython3.dll file exists at this location, but some critical dependency is apparently missing. I searched everywhere and did not find anything useful in this. I have both Python 2 and 3 installed on the machine ...
source
share