I am writing function in postgres in python using the PL/Pythonu extension in postgres. I would like postgres to use my virutal environment (I am using virtualenv) instead of the global install. Ho...

When I call a PostgreSQL PL/Python stored procedure in my Python application, it seems to be executed in a separate process running as user postgres. So far, this only had the side effect that I ha...

I'm trying to install plpython in my Postgres 9.1 but it crashes the server: postgres@dataserver1:~> /opt/postgres/9.1/bin/psql -d mydb psql.bin (9.1.4) Type "help" for help. mydb=# create lan...

I run the exact same Python function, one as a PostgreSQL PL/Python, and the other one outside PostgreSQL as a usual Python script. Surprisingly, when I call the PostgreSQL PL/Python using select ...

I've created some functions in a specific schema, but the "Functions" section has nothing inside.. I create functions like this example: CREATE FUNCTION pymax (a integer, b integer) RETURNS inte...

I am using the following commands below in postgresql 9.1.3 to move data from a temp staging table to a table being used in a webapp (geoserver) all in the same db. Then dropping the temp table. ...

I am using Python (pl/python, actually) to find, successively, a series of regex matches in a very large text object. This is working fine! Each match is a different result, and each replace will b...

i want to install plpython on postgresql to have python trigger when i restore my DB (my db has some python trigger) this error apears (error message was too big so i paste first lines of it): C:...