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 jun. 2020 a las 13:36, PEDRO PABLO SEVERIN HONORATO (< ppseve...@miuandes.cl>) escribió: > 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 and EDB python. > > What happens if you try to create a plpythonu3u function in the database? > > The database crashes and tells me "*Connection to the server has been > lost.*" > > El mié., 10 jun. 2020 a las 13:12, Adrian Klaver (< > adrian.kla...@aklaver.com>) escribió: > >> 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, it helps to keep >> > libraries updated. >> > >> > 2) Do you need the system Python you installed for anything that >> > Anaconda does not provide? >> > >> > A: I don't know if I understood well this question, but I think the >> > answer is no. Anaconda does provide almost all the libraries I need. I >> > just installed a couple more (like talib, tensorflow, keras, psycopg2, >> > etc) and created some libraries of my own. >> >> Those libraries are available from Anaconda: >> >> https://docs.anaconda.com/anaconda/packages/py3.7_win-64/ >> >> or from AnacondaCloud: >> >> https://anaconda.org/ >> >> 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. >> >> >> What happens if you try to create a plpythonu3u function in the database? >> >> >> > >> > 3) What are you planning to do with plpython3u? >> > >> > A: I'm planning to create some functions using python language to >> > process data that is stored in real time in the database and then use >> > them as triggers. I would like to be able to import some libraries that >> > I have in python to do it. Some of the functions are fourier and >> wavelet >> > transforms. If I can't import the library, then I'll have to code the >> > full function, but it's easier (for me) to code them in python language >> > rather than sql language. >> > >> > El mié., 10 jun. 2020 a las 12:17, Adrian Klaver >> > (<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>) >> escribió: >> > >> > 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 execute python functions and create >> the >> > > extension in postgres without problem, but later I realized that >> > doing >> > > this will create the other problem with anaconda. >> > > >> > > So when you did the Anaconda install: >> > > >> > > https://docs.anaconda.com/anaconda/install/windows/ >> > > >> > > What did you check for the Advanced options in Step 8? >> > > >> > > I left the first one unchecked and the second one checked, which >> > is the >> > > default settings. >> > > >> > >> > 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? >> > >> > 2) Do you need the system Python you installed for anything that >> > Anaconda does not provide? >> > >> > 3) What are you planning to do with plpython3u? >> > >> > >> > -- >> > Adrian Klaver >> > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >> > >> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com >> >
