Re: Help with plpython3u

2020-06-10 Thread Adrian Klaver
On 6/10/20 4:35 PM, PEDRO PABLO SEVERIN HONORATO wrote: 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

Re: Help with plpython3u

2020-06-10 Thread PEDRO PABLO SEVERIN HONORATO
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 Stack

Re: Help with plpython3u

2020-06-10 Thread Adrian Klaver
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 exe

Re: Help with plpython3u

2020-06-10 Thread PEDRO PABLO SEVERIN HONORATO
I just think it would make your life easier to reduce the number of Python installs you have. If I'm keeping track correctly you now have: 1) Anaconda Python 2) OS system Python 3) EDB Python. The OS is windows, and afaik python is not included in windows, so it would be just Anaconda python an

Re: Help with plpython3u

2020-06-10 Thread Adrian Klaver
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 exe

Re: Help with plpython3u

2020-06-10 Thread PEDRO PABLO SEVERIN HONORATO
I'm sorry, when I try to create a plpython3u function, the database tells me: " *ERROR: could not load library "C:/ProgramFiles/PostgreSQL/12/lib/plpython3.dll": The specified module could notbe found. SQL state: 58P01*" If I try to execute the function, then the database crashes. El mié., 10 j

Re: Help with plpython3u

2020-06-10 Thread Adrian Klaver
On 6/10/20 9:57 AM, PEDRO PABLO SEVERIN HONORATO wrote: Alright. Before we go any further it would be best to determine what your needs are. So: 1) Did you install Anaconda just to get Python or for the science data set of libraries it provides? A: For the data science set of libraries. Also, i

Re: Help with plpython3u

2020-06-10 Thread PEDRO PABLO SEVERIN HONORATO
Alright. Before we go any further it would be best to determine what your needs are. So: 1) Did you install Anaconda just to get Python or for the science data set of libraries it provides? A: For the data science set of libraries. Also, it helps to keep libraries updated. 2) Do you need the sys

Re: Help with plpython3u

2020-06-10 Thread Adrian Klaver
On 6/10/20 8:25 AM, PEDRO PABLO SEVERIN HONORATO wrote: Just to be clear those where instructions from here, correct?: https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/language-pack-guide/12/EDB_Postgres_Language_Pack_Guide.1.08.html# Yes. When I did that I could

Re: Help with plpython3u

2020-06-10 Thread PEDRO PABLO SEVERIN HONORATO
Just to be clear those where instructions from here, correct?: https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/language-pack-guide/12/EDB_Postgres_Language_Pack_Guide.1.08.html# Yes. When I did that I could execute python functions and create the extension in post

Re: Help with plpython3u

2020-06-10 Thread Adrian Klaver
On 6/10/20 7:39 AM, PEDRO PABLO SEVERIN HONORATO wrote: Thank you Adrian, will see the link you sent me. Thank you, Laurenz. I noticed that copying the DLL is not a good idea. How can I set a python path for postgres, so that I tell postgres "hey, if you are looking for python see this path" an

Re: Help with plpython3u

2020-06-10 Thread PEDRO PABLO SEVERIN HONORATO
Thank you Adrian, will see the link you sent me. Thank you, Laurenz. I noticed that copying the DLL is not a good idea. How can I set a python path for postgres, so that I tell postgres "hey, if you are looking for python see this path" and don't lose conda? Because after following all Adrian's in

Re: Help with plpython3u

2020-06-10 Thread Adrian Klaver
On 6/9/20 10:38 PM, PEDRO PABLO SEVERIN HONORATO wrote: Thank you, Adrian. Will read about all this. By the way, the issue reappeared. For some reason, I had to reinstall Anaconda and had to delete the "PYTHONHOME" variable because I could not launch conda. Seems that they both fight for the sa

Re: Help with plpython3u

2020-06-09 Thread Laurenz Albe
On Tue, 2020-06-09 at 20:26 -0400, PEDRO PABLO SEVERIN HONORATO wrote: > I installed Postgres downloading the file posgresql-12.2-1-windows-x64 from > the website https://www.postgresql.org/download/windows/. > > The python37.dll I copied to the System32 folder was located in > C:\Users\develop

Re: Help with plpython3u

2020-06-09 Thread PEDRO PABLO SEVERIN HONORATO
Thank you, Adrian. Will read about all this. By the way, the issue reappeared. For some reason, I had to reinstall Anaconda and had to delete the "PYTHONHOME" variable because I could not launch conda. Seems that they both fight for the same variable name? Is there a way to set it to two different

Re: Help with plpython3u

2020-06-09 Thread Adrian Klaver
On 6/9/20 6:17 PM, PEDRO PABLO SEVERIN HONORATO wrote: Thanks Adrian, this actually helped me. I was looking for the "language pack" thing without any success and thanks god that you pointed me in the right direction :) What I don't understand is the following. After installing the language p

Re: Help with plpython3u

2020-06-09 Thread PEDRO PABLO SEVERIN HONORATO
Thanks Adrian, this actually helped me. I was looking for the "language pack" thing without any success and thanks god that you pointed me in the right direction :) What I don't understand is the following. After installing the language pack with stack builder, added a variable named "PYTHONHOME"

Re: Help with plpython3u

2020-06-09 Thread Adrian Klaver
On 6/9/20 5:26 PM, PEDRO PABLO SEVERIN HONORATO wrote: Hi Adrian, I installed Postgres downloading the file posgresql-12.2-1-windows-x64 from the website https://www.postgresql.org/download/windows/. Did you go through the steps here?: https://www.enterprisedb.com/edb-docs/d/postgresql/user-

Re: Help with plpython3u

2020-06-09 Thread PEDRO PABLO SEVERIN HONORATO
Hi Adrian, I installed Postgres downloading the file posgresql-12.2-1-windows-x64 from the website https://www.postgresql.org/download/windows/. The python37.dll I copied to the System32 folder was located in C:\Users\developer\Anaconda3. After trying this, I installed python 3.7.0 and copied the

Re: Help with plpython3u

2020-06-09 Thread Adrian Klaver
On 6/9/20 5:09 PM, PEDRO PABLO SEVERIN HONORATO wrote: Hello! I'm cracking my head while trying to make python language work within postges. I executed "*create extension plpython3u*" but I get this error: "*ERROR: could not load library "C:/Program Files/PostgreSQL/12/lib/plpython3.dll": Th

Help with plpython3u

2020-06-09 Thread PEDRO PABLO SEVERIN HONORATO
Hello! I'm cracking my head while trying to make python language work within postges. I executed "*create extension plpython3u*" but I get this error: "*ERROR: could not load library "C:/Program Files/PostgreSQL/12/lib/plpython3.dll": The specified module could not be found. SQL state: 58P01*" L