pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16221: ERROR while importing Plpython , pltcl
5+ messages / 5 participants
[nested] [flat]
* BUG #16221: ERROR while importing Plpython , pltcl
@ 2020-01-21 07:35 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: PG Bug reporting form @ 2020-01-21 07:35 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: kalyan.singh@capgemini.com
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: BUG #16221: ERROR while importing Plpython , pltcl
@ 2020-01-21 08:53 Julien Rouhaud <rjuju123@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 2 replies; 5+ messages in thread
From: Julien Rouhaud @ 2020-01-21 08:53 UTC (permalink / raw)
To: kalyan.singh@capgemini.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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?
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: BUG #16221: ERROR while importing Plpython , pltcl
@ 2020-01-21 09:13 Singh, Kalyan <kalyan.singh@capgemini.com>
parent: Julien Rouhaud <rjuju123@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Singh, Kalyan @ 2020-01-21 09:13 UTC (permalink / raw)
To: Julien Rouhaud <rjuju123@gmail.com>; PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Hi,
No, But when I have tried to install in my home laptop then there also I got the same error (the antivirus is not installed in my home laptop).
Is there any way to send mail through postgres without using plpython,plperl or pltcl.
With Regards,
Kalyan Singh / Capgemini India / Kolkata
Smart Energy Services Platform (SESP)
www.capgemini.com
Mobile: - (+91) 99033441775
Together. Free your energies
_______________________________________
Machines will never exceed human intelligence.
-----Original Message-----
From: Julien Rouhaud [mailto:rjuju123@gmail.com]
Sent: Tuesday, January 21, 2020 2:24 PM
To: Singh, Kalyan; PostgreSQL mailing lists
Subject: Re: BUG #16221: ERROR while importing Plpython , pltcl
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?
This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: BUG #16221: ERROR while importing Plpython , pltcl
@ 2020-01-21 15:16 Tom Lane <tgl@sss.pgh.pa.us>
parent: Julien Rouhaud <rjuju123@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Tom Lane @ 2020-01-21 15:16 UTC (permalink / raw)
To: Julien Rouhaud <rjuju123@gmail.com>; +Cc: kalyan.singh@capgemini.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Julien Rouhaud <rjuju123@gmail.com> writes:
> On Tue, Jan 21, 2020 at 8:35 AM PG Bug reporting form
> <noreply@postgresql.org> wrote:
>> 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.
> 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?
Another likely theory is that the message is not trying to complain
about plpython2.dll, but about some library that that depends on,
probably libpython itself. If you look into the postmaster log file,
rather than just at what's reported to the client, you might find
some additional low-level messages clarifying this.
If this were a Linux machine I'd recommend using "ldd" to investigate
the dependencies of plpython2.dll. But I don't know what the equivalent
tool for Windows is.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: BUG #16221: ERROR while importing Plpython , pltcl
@ 2020-01-21 17:18 Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Juan José Santamaría Flecha @ 2020-01-21 17:18 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Julien Rouhaud <rjuju123@gmail.com>; kalyan.singh@capgemini.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Tue, Jan 21, 2020 at 4:16 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Julien Rouhaud <rjuju123@gmail.com> writes:
> > On Tue, Jan 21, 2020 at 8:35 AM PG Bug reporting form
> > <noreply@postgresql.org> wrote:
> >> 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.
>
> > 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?
>
> Another likely theory is that the message is not trying to complain
> about plpython2.dll, but about some library that that depends on,
> probably libpython itself. If you look into the postmaster log file,
> rather than just at what's reported to the client, you might find
> some additional low-level messages clarifying this.
>
Your python installation must match the version of the plpython2.dll, so
python 3.8 won't work.
Also make sure the python path is added to the PATH environment variable.
> If this were a Linux machine I'd recommend using "ldd" to investigate
> the dependencies of plpython2.dll. But I don't know what the equivalent
> tool for Windows is.
>
>
This would be Dependencies:
https://github.com/lucasg/Dependencies
TL;DR If your plpython2.dll points to python27.dll, you will need a
python 2.7 installation in your PATH.
Regards,
Juan José Santamaría Flecha
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2020-01-21 17:18 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-01-21 07:35 BUG #16221: ERROR while importing Plpython , pltcl PG Bug reporting form <noreply@postgresql.org>
2020-01-21 08:53 ` Julien Rouhaud <rjuju123@gmail.com>
2020-01-21 09:13 ` Singh, Kalyan <kalyan.singh@capgemini.com>
2020-01-21 15:16 ` Tom Lane <tgl@sss.pgh.pa.us>
2020-01-21 17:18 ` Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox