Re: Help with plpython3u

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 I'm going to have to review where we are at. That will not
happen for a bit, so hang on.

>
> El mié., 10 jun. 2020 a las 13:36, PEDRO PABLO SEVERIN HONORATO
> (<ppseverin(at)miuandes(dot)cl <mailto:ppseverin(at)miuandes(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com