I have installed 64-bit Postgres 9.1 on Windows 7 Enterprise (64-bit). I also have 64-bit Python 2.7.2 and 2.6 installed. I am interested in using PL\Python but am having trouble installing it.
I read the intro documentation on PL/Python with respect to the plpython2 vs 3 issues. My installation only had plpython3.dll installed into C:\Program Files\PostgreSQL\9.1\lib. I found a copy of plpython2.dll and copied it into lib. When I try to create the extension I get an error about the dll:
c:\>C:\Progra~1\PostgreSQL\9.1\bin\createlang.exe --dbname=postgres --echo -U postgres plpythonu
SELECT oid FROM pg_catalog.pg_language WHERE lanname = 'plpythonu';
CREATE EXTENSION "plpythonu";
createlang: language installation failed: ERROR: could not load library "C:/Program Files/PostgreSQL/9.1/lib/plpython2.dll": %1 is not a valid Win32 application.
I suspect the dll is for 32-bit Postgres/Python. Does anyone know where I can find the plpython DLL that will let me use 64-bit Python 2.7.x on Windows?
Thanks!
