Menu

#245 Temporary objects when session is reloaded

Development Queue
open
nobody
5
2012-06-03
2011-12-01
No

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.

Discussion

  • Abbas Butt

    Abbas Butt - 2012-03-10
    • labels: 2091149 --> Database Server
    • milestone: --> 2663467
     
  • Koichi Suzuki

    Koichi Suzuki - 2012-06-03

    Workaround will be to disconnect the session to make temporary object in consistent state.

     
  • Koichi Suzuki

    Koichi Suzuki - 2012-06-03
    • milestone: 2663467 --> Development Queue
    • assigned_to: michaelpq --> nobody
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.