> For additional entertainment, I include patches that integrate > background sessions into dblink. So dblink can open a connection to a > background session, and then you can use the existing dblink functions > to send queries, read results, etc. People use dblink to make > self-connections to get autonomous subsessions, so this would directly > address that use case. The 0001 patch is some prerequisite refactoring > to remove an ugly macro mess, which is useful independent of this. 0002 > is the actual patch.
Updated patch, mainly with improved error handling and some tidying up.
I am checking this patch. I have few questions ( I didn't find a reply in doc)
1. will be background session process closed automatically when parent process is closed?
2. what timeouts are valid for this process - statement timeout, idle in transaction timeout
I see significant risk on leaking sessions.
There can be more doc and examples in plpython doc. It will be main interface for this feature. Mainly about session processing.
Regards
Pavel
p.s. It is great functionality and patch looks very well.