something like EDB_PYTHONHOME that only the Postgres install would use. That's exactly what I was looking for. Isn't a way to configure some postgres file, so that postgres would use that file and look for python in that directory before seeing the path?
I guess you have to ask questions on Stackoverflow Stackoverflow was the first place where I asked this, but with less knowledge than now. Maybe now I can ask a more concrete question about paths. Anyways, thank you very much for your time, Adrian. I really appreciate it. If I manage to solve this I'll let you know, so if anyone else has the same problem. El mié., 10 jun. 2020 a las 18:19, Adrian Klaver (<adrian.kla...@aklaver.com>) escribió: > On 6/10/20 10:39 AM, PEDRO PABLO SEVERIN HONORATO wrote: > > I'm sorry, when I try to create a plpython3u function, the database > > tells me: > > > > "*ERROR: could not load library "C:/Program > > Files/PostgreSQL/12/lib/plpython3.dll": The specified module could not > > be found. SQL state: 58P01*" > > > > If I try to execute the function, then the database crashes. > > > > Alright that was not fun. I pulled up an Windows 7 machine and installed > Anaconda and Postgres from EDB. I installed Anaconda with the defaults > you mentioned. I could not get Anaconda and Postgres to work together > with regards to Python. As you have found the PYTHONHOME setting > Postgres needs is picked up by Anaconda and prevents it from starting. > Dropping PYTHONHOME allows Anaconda to work but causes plpython3u to > fail. To me the solution would be to have something like EDB_PYTHONHOME > that only the Postgres install would use. I could not find anything like > that though. I'm out of ideas. I now remember why I don't use Windows:( > I was going to point you at the EDB forums, but they don't exist > anymore. I guess you have to ask questions on Stackoverflow: > > https://stackoverflow.com/questions/tagged/enterprisedb > > I would try there. > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
