171 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
58
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 ...
- 331
0
votes
1
answer
293
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 ...
- 1
2
votes
0
answers
648
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
139
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
263
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
814
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
427
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
150
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 ...
- 4,747
1
vote
0
answers
345
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
377
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,502
1
vote
1
answer
103
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....
- 125
1
vote
1
answer
357
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 ...
- 125
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
1
vote
0
answers
76
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,104