170 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
62
views
Why plpython functions increase transaction counter much more then plpgsql functions?
I'm trying to understand why plpython function has much bigger impact on transaction counter in Postgres than plpgSQL function. Below is example which uses 2 functions:
Vesion with plpgSQL (each part ...
0
votes
1
answer
311
views
Postgres - TypeError: tabulate() got an unexpected keyword argument 'colalign'
I have problem in Postgres 16.2 with plpython procedure and library tabulate.
I created procedure:
CREATE OR REPLACE PROCEDURE dpl.__test_tabulate()
LANGUAGE plpython3u AS $plpy$
from tabulate import ...
2
votes
0
answers
656
views
"ERROR: could not load library "C:/Program Files/PostgreSQL/14/lib/plpython3.dll": The specified module could not be found." plpython3u Windows 10
When ever I try to create extension plpython3u
ERROR: could not load library "C:/Program Files/PostgreSQL/14/lib/plpython3.dll": The specified module could not be found.
This message shows ...
0
votes
0
answers
147
views
python function for plpython3u
I have a python function that works perfectly, but I need to pass it to plpython3u (don't ask me why, juniors only obey)
python function:
import cryptography.hazmat.primitives.serialization.pkcs12 ...
0
votes
0
answers
273
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()
...
0
votes
0
answers
861
views
An I/O error occurred while sending to the backend postgresql
Just so you understand my case:
Recently I was trying to install plpython3u on postgresql 15, and with a lot of struggle I managed
I set the python environment variables (both for system and user) and ...
0
votes
0
answers
481
views
ERROR: could not load library plpython3u postgresql
I'm trying to install the plpython3u extension in my postgresql with this command: CREATE EXTENSION plpython3u;
mas eu recebo este erro:
ERROR: could not load library "C:/Program Files/PostgreSQL/...
0
votes
2
answers
165
views
plpy does not print on the postgres log
I have a plpython trigger function and I'm trying to log something in it to better understand what it does, but I can't manage to print anything on the postgres log file.
I have tried different level ...
1
vote
0
answers
358
views
how to install python3 in postgres
I'm trying to work with plpython in postgresql
So I run the command:
CREATE EXTENSION plpython3u
but I get the error:
Erro SQL [58P01]: ERROR: could not load library "C:/Program Files/PostgreSQL/...
2
votes
2
answers
388
views
PostgreSQL Procedure using python write dataframe to table
I am developing a PostgreSQL Procedure using the plpython3u extension which let you use python procedural language into PostgreSQL.
With the following code using plpy, I am able to retrive data form ...
1
vote
1
answer
112
views
plpygis can't find shapely dependency
I have a problem with the plpygis library for python. Whenever I'm trying to convert a plpygis Point type into its shapely counterpart, I get the following error:
ERROR: plpygis.exceptions....
1
vote
1
answer
364
views
Use virtual environment for plpython3u in PostgreSQL
I'm trying to use packages from an existing virtual environment within the plpython3u extension for PostgreSQL. I found and followed this tutorial, but it didn't work.
Firstly, the configuration file ...
0
votes
1
answer
2k
views
Update Redis cache value from PostgreSQL
I am working on a Python project and I have a requirement that whenever a row is inserted, updated, or deleted in a PostgreSQL table, the corresponding value should be updated in Redis. I am working ...
1
vote
0
answers
80
views
Are `AFTER UPDATE` triggers `FOR EACH ROW` atomic?
I'd like to insert a row inside a "history" table whenever the original row gets modified (updated). I'd like to use original row's ID as a FOREIGN KEY for the history table. But this ID ...
2
votes
1
answer
211
views
problem to access of the properties of an edge when using plpython3u in PostgreSQL to create functions
I implement python function for for the following query and i get correct answer, but when i try to create functions in postgreSQL by using plpython3u extension, it doesn't have any error but still ...