I am using PostgreSQL 9.0.1 on Windows 7.0 Ultimate 64bit.
I tried to use plpython within one of my databases, but installing the language fails with:
C:\Program Files\PostgreSQL\9.0\lib>createlang --dbname=ibox --echo -U postgres plpythonu
SELECT oid FROM pg_catalog.pg_language WHERE lanname = 'plpythonu';
CREATE LANGUAGE "plpythonu";
createlang: Installation der Sprache fehlgeschlagen: FEHLER: Âkonnte Bibliothek ÃÂC:/Program Files/PostgreSQL/9.0/lib/pl
python.dllÃÂ nicht laden: %1 is not a valid Win32 application.
(which translated to english is roughly:
createlang: Installation of language failed: ERROR: Âcould not load library ÃÂC:/Program Files/PostgreSQL/9.0/lib/plpython.dllÃÂ : %1 is not a valid Win32 application.
Should'nt plplython.dll be a valid win32_x64 application when being loaded into PostgreSQL 64bit? Could this be the source of the error? (as in: "plpython.dll is 32 bit, PostgreSQL is 64bit, so no loading of 32-bit-module into 64-bit-process?)
Harald
--Â
GHUM GmbHHarald Armin Massa
Spielberger StraÃe 49
70435 Stuttgart
0173/9409607
Amtsgericht Stuttgart, HRB 734971
-
persuadere.
et programmare
