Re: BUG #16221: ERROR while importing Plpython , pltcl - Mailing list pgsql-bugs

From Julien Rouhaud
Subject Re: BUG #16221: ERROR while importing Plpython , pltcl
Date
Msg-id CAOBaU_ZTzoJ=e_MTRTLvnP3vqx4aocnSZAq2pMcFDrHh8vz9+A@mail.gmail.com
Whole thread Raw
In response to BUG #16221: ERROR while importing Plpython , pltcl  (PG Bug reporting form <noreply@postgresql.org>)
Responses RE: BUG #16221: ERROR while importing Plpython , pltcl  ("Singh, Kalyan" <kalyan.singh@capgemini.com>)
Re: BUG #16221: ERROR while importing Plpython , pltcl  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Tue, Jan 21, 2020 at 8:35 AM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      16221
> Logged by:          kalyan singh
> Email address:      kalyan.singh@capgemini.com
> PostgreSQL version: 11.0
> Operating system:   WINDOWS 10
> Description:
>
> We are trying to import  “plpythonu” in postgresql  but when running the
> below query we are getting an error:-
> CREATE EXTENSION plpythonu
>  ERROR:  could not load library "C:/Program
> Files/PostgreSQL/11/lib/plpython2.dll": The specified module could not be
> found.
> Although I have “plpython2.dll” is there in the same location.
> I have tried CREATE EXTENSION plpythonu3  getting same error although I have
> all the  .control file in the expected location.
> I have also tried to import pltcl but getting same error.
> My python version is -3.8
>
> Can you please help us to overcome this issue.
> Need this because we need to send mail through a procedure in postgresql.

If all the files are present in the expected location, this is
probably due to wrong privilege access on the files, or some antivirus
preventing postgres from loading the libs.  Have you tried after
disabling the antivirus or configuring an exception for the postgres'
directories?



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16221: ERROR while importing Plpython , pltcl
Next
From: "Singh, Kalyan"
Date:
Subject: RE: BUG #16221: ERROR while importing Plpython , pltcl