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

[<david@xxxxxxxx>]

Thank you for your response.

 

Yes, I was aware of GD and SD. My question is about what facilities Postgres provides for implementing such a thing. Where is the proper place for the root of the SD/GD? What does an implementation use to determine that two calls belong to the same session?

 

I’m not finding that easy to understand by reading source code.

 

Regards

David M Bennett FACS

---

MD Powerflex Corporation, creators of PFXplus

To contact us, please call +61-3-9548-9114 or go to www.pfxcorp.com/contact.htm

 

From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of David G. Johnston
Sent: Monday, 7 March 2016 4:28 PM
To: david@xxxxxxxx
Cc: pgsql-general-owner+M220479=david=andl.org@xxxxxxxxxxxxxx; pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Subject: Re: Does a call to a language handler provide a context/session, and somewhere to keep session data?

 

On Sun, Mar 6, 2016 at 10:21 PM, <david@xxxxxxxx> wrote:

Given that a language handler would be expected to be persistent, and to support concurrent (and reentrant) calls within a single database, is there a unique context or session identifier available?

Is there a place to store data, to be retrieved later in the same session?

Is there a place to store data (a cache?) that has been retrieved from the database for use by concurrent sessions using that database?

 

http://www.postgresql.org/docs/9.5/interactive/plpython-sharing.html

 

​PL/R also has an implementation for this kind of thing.

 

David J.