Hey, thanks to help me with that.
I started fresh to have a truly reproducible process,
so you can have all information and rule out some error possibilities.
- Uninstall all python.
- Check that PythonPath doesn't exist anymore
- check that python doesn't exist anymore
- install python 3.2.5 64 bit from official python website into C/Python32
- Reload configuration for server.
- create plpython3u , create a python function, test it (show path)
* It works, python path is
'C:\\Windows\\system32\\python32.zip', 'C:\\Python32\\Lib', 'C:\\Python32\\DLLs', 'E:\\9.3\\data', 'C:\\Program Files\\PostgreSQL\\9.3\\bin', 'C:\\Python32', 'C:\\Python32\\lib\\site-packages'
- Donwload latest numpy from website.
- ON antoher PC
* Compile numpy with visual 2008 , 64 bit
* Create an binary installer for windows (using python.exe setup.py )with proper argument
- On the server :
- install numpy with the compiled installer.
- check that numpy is correctly installer in C:\Python32\Lib\site-packages
- using an external terminal, check that numpy works (import numpy -> OK)
- Now, define a plpython3u function containing "import numpy"
- Run the function --> error is
"ERREUR: ImportError: DLL load failed: Le module spécifié est introuvable.",
which roughly translate to
"ERROR: ImportError : DLL load failed : the specified module couldn't be found".
- Create a plpython3u function returning sys.path
the path is "C:\\Windows\\system32\\python32.zip', 'C:\\Python32\\Lib', 'C:\\Python32\\DLLs', 'E:\\9.3\\data', 'C:\\Program Files\\PostgreSQL\\9.3\\bin', 'C:\\Python32', 'C:\\Python32\\lib\\site-packages"
numpy is in this path, in C:\\Python32\\lib\\site-packages
All user of the computer have all rights on the C:\\Python32\\lib\\site-packages folder
- execute `import imp; imp.find_package('numpy')` within the plpython3u function
-> returns "None, 'C:\\Python32\\lib\\site-packages\\numpy', ('', '', 5)"
- create a helloworld module , put it next to numpy, try to call it
-> it gets called
I really don't see what I can do more.
Cheers,
Rémi-C
