vibhorkum / pg_background

pg_background
GNU General Public License v3.0
136 stars 35 forks source link

pg_background can not access temp tables of a parent function #26

Closed MaximRambo closed 4 years ago

MaximRambo commented 4 years ago

as it was discussed in https://github.com/vibhorkum/pg_background/issues/8 configuration variables can be used (via set_config, current_setting) but what about accessing data in temp tables? In my case in parent function there is a creation of temp table with data inside and I want to be able to get the data from that table in my inner function that was called via pg_background.

Thank you, in advance

vibhorkum commented 4 years ago

You cannot access temp tables using pg_background. pg_background opens a new session and it doesn't have any visibility on temporary tables of parent session.

vibhorkum commented 4 years ago

Cannot be fixed!