CREATE PROCEDURAL LANGUAGE plpythonu on windows, with EDB's 8.4.2 installer causes error

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: CREATE PROCEDURAL LANGUAGE plpythonu on windows, with EDB's 8.4.2 installer causes error
Date: 2010-07-08 10:47:32
Message-ID: AANLkTilMEsLE8mPYxaFHLPhM0MJYJtPhDYn8zB_JNxHU@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When attempting to restore a dump of a database with a pl/pythonu
function, I encountered the following error (recreated here with
psql):

postgres=# \c lustre
psql (8.4.2)
WARNING: Console code page (850) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
You are now connected to database "lustre".
lustre=# CREATE PROCEDURAL LANGUAGE plpythonu;
ERROR: could not load library "C:/Program Files/PostgreSQL/8.4/lib/plpython.dll
": The specified module could not be found.

This is a throwaway VM that I intend to do a little bit of testing on.
I installed python 2.7 for windows, thinking that the module that
wasn't found was another dll that plpython.dll was in turn dependent
on, but doing so hasn't helped - besides, I always understood that the
shipped PLs don't have any external dependencies (the docs indicate
that it's a simple matter of "createlang plpythonu dbname"). It's
quite clear that plpython.dll does exist in the directory specified.
What should I do?

--
Regards,
Peter Geoghegan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2010-07-08 11:30:41 Re: CREATE PROCEDURAL LANGUAGE plpythonu on windows, with EDB's 8.4.2 installer causes error
Previous Message Alban Hertroys 2010-07-08 09:42:51 Re: \COPY ... CSV with hex escapes