Skip to main content

All 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 ...
Crazy Clown's user avatar
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 ...
Khizar Iqbal's user avatar
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 ...
Kaushik Acharya's user avatar
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() ...
AndCh's user avatar
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 ...
jiquvox's user avatar
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 ...
dvidmon's user avatar
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....
mateo's user avatar
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 * ...
Nilesh Navale's user avatar

close