PL/Python SD dict wiped?

2018-01-08 Thread Ken Huffman
Is there a known issue with the PL/Python extension clearing the SD dict under some circumstances? As suggested by the documentation, my plpythonu uses the SD dict for one-time (prepare and ConfigParser) logic: CREATE OR REPLACE FUNCTION change_notify() RETURN TRIGGER AS $$ ... If len(SD) == 0:

RE: PL/Python SD dict wiped?

2018-01-08 Thread Ken Huffman
I'm fine with per-session initializing of prepared statements, but is there PL/Python mechanism that spans sessions to minimize ConfigParser calls? -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, January 08, 2018 10:23 AM To: Ken Huffman Cc: Pg Ha