Re: Ticket 117: Explain Buffers - Mailing list pgadmin-hackers

From Euler Taveira de Oliveira
Subject Re: Ticket 117: Explain Buffers
Date
Msg-id 4B5E5DC8.7030706@timbira.com
Whole thread Raw
In response to Re: Ticket 117: Explain Buffers  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Ticket 117: Explain Buffers  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-hackers
Guillaume Lelarge escreveu:
> New patch attached.
>
Nice job. But there are just a few gripes about your patch: (i) it doesn't
disable the EXPLAIN button when the BUFFERS option is enabled, (ii) it doesn't
disable the EXPLAIN ANALYZE menu when the query is running, and (iii) there is
a bug when the BUFFERS option is enabled and you close and open the query tool
again (the EXPLAIN menu turns enabled instead of disabled).

The attached patch (on the top of your patch) addresses all of these problems.


--
  Euler Taveira de Oliveira
  http://www.timbira.com/
*** pgadmin/frm/frmQuery.cpp.orig    2010-01-26 00:52:01.000000000 -0200
--- pgadmin/frm/frmQuery.cpp    2010-01-26 00:54:01.000000000 -0200
***************
*** 1892,1897 ****
--- 1892,1900 ----
  void frmQuery::OnBuffers(wxCommandEvent& event)
  {
      queryMenu->Enable(MNU_EXPLAIN, !queryMenu->IsChecked(MNU_BUFFERS));
+     toolBar->EnableTool(MNU_EXPLAIN, !queryMenu->IsChecked(MNU_BUFFERS));
+
+     settings->SetExplainBuffers(queryMenu->IsChecked(MNU_BUFFERS));
  }

  // Update the main SQL query from the GQB if desired
***************
*** 2111,2122 ****
      toolBar->EnableTool(MNU_EXECUTE, !running);
      toolBar->EnableTool(MNU_EXECPGS, !running);
      toolBar->EnableTool(MNU_EXECFILE, !running);
!     toolBar->EnableTool(MNU_EXPLAIN, !running);
      toolBar->EnableTool(MNU_CANCEL, running);
      queryMenu->Enable(MNU_EXECUTE, !running);
      queryMenu->Enable(MNU_EXECPGS, !running);
      queryMenu->Enable(MNU_EXECFILE, !running);
!     queryMenu->Enable(MNU_EXPLAIN, !running);
      queryMenu->Enable(MNU_CANCEL, running);
      fileMenu->Enable(MNU_EXPORT, sqlResult->CanExport());
      fileMenu->Enable(MNU_QUICKREPORT, sqlResult->CanExport());
--- 2114,2126 ----
      toolBar->EnableTool(MNU_EXECUTE, !running);
      toolBar->EnableTool(MNU_EXECPGS, !running);
      toolBar->EnableTool(MNU_EXECFILE, !running);
!     toolBar->EnableTool(MNU_EXPLAIN, (!running && !settings->GetExplainBuffers()));
      toolBar->EnableTool(MNU_CANCEL, running);
      queryMenu->Enable(MNU_EXECUTE, !running);
      queryMenu->Enable(MNU_EXECPGS, !running);
      queryMenu->Enable(MNU_EXECFILE, !running);
!     queryMenu->Enable(MNU_EXPLAIN, (!running && !settings->GetExplainBuffers()));
!     queryMenu->Enable(MNU_EXPLAINANALYZE, !running);
      queryMenu->Enable(MNU_CANCEL, running);
      fileMenu->Enable(MNU_EXPORT, sqlResult->CanExport());
      fileMenu->Enable(MNU_QUICKREPORT, sqlResult->CanExport());

pgadmin-hackers by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Ticket 117: Explain Buffers
Next
From: Guillaume Lelarge
Date:
Subject: Re: Ticket 117: Explain Buffers