At the moment, I have functions in PostgreSql that create temporary tables, fill them and then drop them at the end of the function (which for Postgresql is the end of transaction)
The key benefit Postgresql offers me is that these temp tables are local to function execution scope, that is, two simultaneous calls to same postgres function would create the temp table with the same name, but they would not see/touch each others data.
I was wondering if I can do the same thing with VoldDB. Create and drop temp tables visible only to the execution context of a stored procedure.
Apologies for being lazy and asking this question instead of setting up voltdb and trying it out. Your response will save me at least a few hours, which would mean a lot for me at the moment.