When a session is reloaded with pgxc_pool_reload, prepared objects are correctly dropped on session on local nodes and remote nodes, but temporary objects are only dropped on remote nodes, causing temporary tables to exist on local Coordinator but not on remote nodes.
It could be possible to drop temporary objects but in order to do that a transaction needs to be open when dropping temporary objects in the same way done as when proc is shut down. For the time being, temporary objects are dropped neither on the session that invocated pgxc_pool_reload nor on the other backend sessions.
Workaround will be to disconnect the session to make temporary object in consistent state.