Python code caching in PostgreSQL?

Question

I am writing some common functions to use in pl/Python in PostgreSQL.

The python modules are loaded into PL/Python functions by:

from sys import path
path.append('/PythonLibrary/PostgreSQL')
from Module import funcA, funcB, etc

This works OK until you change the module source code. The server has the code cached, or in a compiled state, but it fails to detect changes and reload.

How is Postgres handling this, and how can I get changes detected and handled appropriately.

Thanks.

try restarting the server (postgresql)

rachid
– rachid

2017-10-13 22:25:47 +00:00
Commented Oct 13, 2017 at 22:25 — rachid
– rachid, Commented Oct 13, 2017 at 22:25
I was hoping to avoid doing that.

Crashmeister
– Crashmeister

2017-10-13 22:29:16 +00:00
Commented Oct 13, 2017 at 22:29 — Crashmeister
– Crashmeister, Commented Oct 13, 2017 at 22:29

klin · Accepted Answer · 2017-10-14 00:28:53Z

2

Use the function reload(module), example (Python 3.3):

from imp import reload
import my_module
my_module = reload(my_module)
from my_module import my_function

In Python 2 reload() is a built-in function, in Python 3 it was moved to the imp module, in 3.4 and later it is in importlib.

answered Oct 14, 2017 at 0:28

klin

123k15 gold badges240 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python code caching in PostgreSQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related