Skip site navigation (1) Skip section navigation (2)

PL/Python on Postgres 9.1

From: Josh Hemann <josh(dot)hemann(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PL/Python on Postgres 9.1
Date: 2012-02-27 22:07:35
Message-ID: CAEpXN1wANEX_86TbQZFG8hwaTB8Ke3B=Jw5KSAt7Zi9KnMaidw@mail.gmail.com (view raw or flat)
Thread:
Lists: 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

Next:From: Adrian KlaverDate: 2012-02-27 22:16:47
Subject: Re: Having a problem with RoR-3.1.1 and Pg-9.1
Previous:From: Ireneusz PlutaDate: 2012-02-27 21:57:04
Subject: Re: pg_class.relnamespace NOT IN pg_namespace.oid

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group