Re: Does a call to a language handler provide a context/session, and somewhere to keep session data?

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of John R Pierce

this stuff you're loading from the database once, that's just data about your language plugin's configuration, or is it
userdata, or what? 
[dmb>] It's the catalog for Andl. It contains defined functions, types, persistent scalar (non table) data values and
linksto tables.  

if its just a few global settings, you should consider using custom
settings variables, rather than database tables.   for instance, pljava has a setting,
pljava.libjvm_location='/usr/lib/jvm/java-1.8.0/lib/libjvm.so' or whatever which it uses to find the Java native calls
interfacelibrary... 
[dmb>] Andl has something similar, but that problem is already solved.

Regards
David M Bennett FACS

Andl - A New Database Language - andl.org