21 questions
0
votes
0
answers
38
views
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....
- 89
0
votes
0
answers
265
views
how to download modules to use with plpython postgresql
I'm trying to use plpython3u with postgresql on windows 11, and I want to use the requests library to make http requests..
So I did this test function:
CREATE OR REPLACE FUNCTION teste()
...
1
vote
0
answers
74
views
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()
...
- 339
0
votes
0
answers
42
views
Using dask delayed function from within postgresql plpython with "plpy.execute"
The below example demonstrates using dask delayed funtions (ref) from within postgres plpython while using "plpy.execute" (ref) to query the database.
It returns an error:
ERROR: ...
- 10.4k
0
votes
0
answers
494
views
Error while running plpython function in postgresql
I have Postgresql 12.8.1 version and python 3.7.6 version installed on my system. I want to create a trigger function using plpython so I created plpython3 extension using CREATE EXTENSION plpython3u ....
1
vote
1
answer
1k
views
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 ...
- 11
3
votes
4
answers
7k
views
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 ...
- 495
1
vote
0
answers
148
views
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 ...
- 11
2
votes
2
answers
184
views
Handling backslashes in plpython
CREATE OR REPLACE FUNCTION CLEAN_STRING(in_str varchar) returns varchar
AS
$$
def strip_slashes(in_str):
while in_str.endswith("\\") or in_str.endswith("/"):
in_str = in_str[:-1]
...
- 591
5
votes
1
answer
14k
views
could not load library plpython3.dll
I am getting an error while creating an extension in Postgresql version 10
could not load library "C:/Program Files/PostgreSQL/10/lib/plpython3.dll": The specified module could not be found
CREATE ...
- 547
0
votes
1
answer
104
views
Simple PLPythonu function not visible
I'm working with PLPython3u in Postgres 9.6. I have installed the extra package under Ubuntu and this code runs:
response = db.query([[
CREATE or REPLACE FUNCTION bytea_import() RETURNS void as $$
...
- 14.6k