Ok, thanks guys. Let me check that.
On Sun, Aug 1, 2021 at 10:05 PM Tom Lane wrote:
> Adrian Klaver writes:
> > In that vein the OP could run:
>
> > DO $$
> > import sys
> > plpy.notice(sys.version)
> > $$ LANGUAGE plpython3u;
>
> > in the database to see what plpython3u is actually p
Adrian Klaver writes:
> In that vein the OP could run:
> DO $$
> import sys
> plpy.notice(sys.version)
> $$ LANGUAGE plpython3u;
> in the database to see what plpython3u is actually pointing at?
+1 ... looking at sys.path in the same way would also be useful.
On 8/1/21 8:51 AM, Tom Lane wrote:
Adrian Klaver writes:
Now it's possible that the wording didn't change exactly at the 2/3
boundary, but I doubt it. So it looks to me like the alleged plpython3u
language is actually invoking python 2.something, which is unlikely
to work well at all.
In
Adrian Klaver writes:
> On 8/1/21 7:40 AM, Ganesh Korde wrote:
>> I am trying to run a python function using the language plpython3u and
>> I am getting the below error, though I have installed psutil.
>>
>> postgres=# select * from get_psutil_mem();
>> ERR
below error, though I have installed psutil.
postgres=# select * from get_psutil_mem();
ERROR: ImportError: No module named 'psutil'
CONTEXT: Traceback (most recent call last):
PL/Python function "get_psutil_mem", line 2, in
from psutil import virtual_memory, s
.
postgres=# select * from get_psutil_mem();
ERROR: ImportError: No module named 'psutil'
CONTEXT: Traceback (most recent call last):
PL/Python function "get_psutil_mem", line 2, in
from psutil import virtual_memory, swap_memory
PL/Python function "get_psutil_mem&q