Re: Help with plpython3u

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>