PL/Python on Postgres 9.1 - Mailing list pgsql-general

From Josh Hemann
Subject PL/Python on Postgres 9.1
Date
Msg-id CAEpXN1wANEX_86TbQZFG8hwaTB8Ke3B=Jw5KSAt7Zi9KnMaidw@mail.gmail.com
Whole thread Raw
List pgsql-general
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!

pgsql-general by date:

Previous
From: Ireneusz Pluta
Date:
Subject: Re: pg_class.relnamespace NOT IN pg_namespace.oid
Next
From: Adrian Klaver
Date:
Subject: Re: Having a problem with RoR-3.1.1 and Pg-9.1