All Questions
Tagged with postgres-plpythonpython
8 questions
6votes
1answer
742views
Can python venv be used with plpython3u for postgresql?
I would like plpython3u to use a virtual environment for python. I have seen some (old and not particularly clear) instructions for virtualenv at PostgreSQL PL/Python: call stored procedure in ...
3votes
4answers
7kviews
Install PL/Python on Windows for PostgreSQL 12
I've been working on FHIR for a project and we are using PostgreSQL as a database. While reading docs, I've come to know about PL/Python and decided to give it a shot but I am unable to install the ...
1vote
1answer
383views
PostgreSQL: PL/Python function not taking ARRAY input parameter
Objective: Creating a full text search engine using PostgreSQL FTS. Populating tsvector: I have a tsvector column. To populate tsvector column, I am executing a trigger which calls a procedure which ...
1vote
0answers
73views
plpython3u anaconda environment
I am trying to use an anaconda environment inside my plpython3u function in postgres 15. Here is what I tried so far: DROP FUNCTION use_anaconda_env(); CREATE OR REPLACE FUNCTION use_anaconda_env() ...
1vote
1answer
1kviews
Cannot install plpython for postgres 12
First off , my question is posted after reading many other questions like this one Install PL/Python on Windows for PostgreSQL 12 and various trials of previous methods and comments. But I ve been ...
1vote
0answers
144views
PL/Python is not able to access system variables (LD_LIBRARY_PATH)
I've been trying to create some custom functions in postgresql using PL/Python. However some python libraries import fail because PL/Python has no access to the LD_LIBRARY_PATH variable: CREATE OR ...
0votes
0answers
32views
How to normally output a path containing non-English characters in Popen
it's my function code ~~~~sql DO $$ from subprocess import PIPE,Popen import os import sys env = os.environ.copy() reload(sys) sys.setdefaultencoding('utf-8') plpy.notice(sys....
0votes
0answers
260views
two dimensional arrays not supported in postgresql 9x
Following is the Pl/Python function return 2D array: CREATE FUNCTION return_multidim_py_array(x int4[]) RETURNS int4[] AS $$ plpy.info(x, type(x)) return x $$ LANGUAGE plpythonu; SELECT * ...