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...

I try to add the plpython3 extension to my timescaledb/postgres (based on linux alpine) image: FROM timescale/timescaledb:0.9.0-pg10 RUN set -ex \ && apk add --no-cache --virtual .plpyth...

I have added all of the details I could find, with all of the links, and there is no way to get plpython3u to work on Windows in PostgreSQL 13, it seems. OLD, since the accepted answer shows that v...

I need to import a 3rd party module inside my pl/python function. It seems pl/python uses an internal python that does not have any 3rd party modules. I get this kind of error: ERROR: PL/Python: ...

I have a postgres 11 database running on CentOS 7 and am trying to use PL/python, but need to point to a specific version of the python interpreter. I need to use python3.9 whereas it is using pyth...

I need to install plpython because I'm getting the error could not access file "$libdir/plpython2": No such file or directory when trying to do python manage.py migrate. I have seen different su...

I have a large number of Scottish and Welsh accented place names (combining grave, acute, circumflex and diareses) which I need to update to their unicode normalized form, eg, the shorter form 00E1...

When I create the following function in PostgreSQL: create function log( value variadic text[] ) returns void language plpython3u as $$ print( ' '.join( value ) + '\n' ) $$; do $$ begin perf...

I wanna return table. The function get an array(the query is 'select function_name(array_agg(column_name)) from table_name') I coded below: create type pddesctype as( count float, mean float, st...

In postgres 9.2 I am trying to create a python program that can be a trigger. I want to run an external program (an exe on the local disk) so I am using python to run it. When I try to create a sim...

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 ...

I have a plypython function which does some json magic. For this it obviously imports the json library. Is the import called on every call to the function? Are there any performance implication I ...

I'm trying to write a function in PostgreSQL on Windows with a Python script in the body and i'm running into an error message when trying to create the plpythonu extension. The command I'm running...

I am using a plpython3 stored function, on a postgres database on MacOS (installed with standard Enterprise DB package). I can import standard python packages such as: CREATE OR REPLACE FUNCTION fo...

i'm facing issues in creating extension plpython3u in postgresql 11 create extension plpython3u ERROR: could not load library "C:/Program Files/PostgreSQL/11/lib/plpython3.dll": The specifie...

Both postgres and python3 are already installed on my High Sierra system - so the following was attempted: brew upgrade postgres --with-python I had thought that the --with-python would have ins...

I have always problem with PosgreSQL when new version appears. Again I'm trying to install extension plpython3u and with this hint Error during: CREATE EXTENSION plpython3u; on PostgreSQL 9.6.0 I h...

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 CR...

Is is possible to call a plpgsql function (or any PostgreSQL function) from a PL/Python function? So, something like this: CREATE FUNCTION somefunc() RETURNS void AS $$ DECLARE ... BEGIN ... EN...

I'm trying to install plpython on a postgres server on a Windows machine. When I issue the command CREATE EXTENSION plpython3u; in postgres, I get the following error, which I'm trying to find the ...

I would like to declare and share some simple, pure python functions between two or more PL/Python functions. I am using Postgres 9.3. For example, I have: CREATE OR REPLACE FUNCTION get_mod(mo...

I have tried to install the PL/Python v2.x language inside PostgreSQL on my database running the query: CREATE EXTENSION plpythonu; (I got this from http://www.postgresql.org/docs/9.3/static/plp...

I'm trying to set up CI for some PL/Python PostgreSQL procedures in Travis CI. I've tried several ways: 1) With the legacy infrastructure I've tried to just assume, that PL/Python is already insta...

running CREATE EXTENSION plpython3u gave me the error - The specified module could not be found even if the file is at the correct place. After reading everything on the web, I tried to download a...

Real-world problem: I have data on directors across many firms, but sometimes "John Smith, director of XYZ" and "John Smith, director of ABC" are the same person, sometimes they're not. Also "John...