SVN Commit by dpage: r4932 - in trunk/pgadmin3: . docs/en_US src/frm - Mailing list pgadmin-hackers

Author: dpage
Date: 2006-01-19 13:49:47 +0000 (Thu, 19 Jan 2006)
New Revision: 4932

Modified:
   trunk/pgadmin3/CHANGELOG.txt
   trunk/pgadmin3/docs/en_US/status.html
   trunk/pgadmin3/src/frm/frmStatus.cpp
Log:
Display the client start time on the status dialogue with PostgreSQL 8.1+ [Magnus Hagander]

Modified: trunk/pgadmin3/CHANGELOG.txt
===================================================================
--- trunk/pgadmin3/CHANGELOG.txt    2006-01-19 12:31:41 UTC (rev 4931)
+++ trunk/pgadmin3/CHANGELOG.txt    2006-01-19 13:49:47 UTC (rev 4932)
@@ -8,6 +8,7 @@
     <li>MP  - Marc Persuy
     <li>DAP - Darko Prenosil
     <li>FGP - Florian G. Pflug
+    <li>MH  - Magnus Hagander
 </ul>
 <b>Versions and releases</b><br>
 The following list contains all changes to pgAdmin III, as present in svn.
@@ -18,15 +19,16 @@
 </ul>
 <br>
 <ul>
+    <li>2006-01-19 MH         Display the client start time on the status dialogue with PostgreSQL 8.1+
     <li>2006-01-17 DP         Allow set returning functions to be created.
     <li>2006-01-17 DP  1.4.2  Display the defintion of set returning procedures correctly.
     <li>2006-01-17 DP  1.4.2  Fix drop procedure by including IN/OUT parameter flags in the name.
     <li>2006-01-13 DP  1.4.2  Fix role SQL - correctly define CREATEROLE/NOCREATEROLE per Andrus.
-    <li>2006-01-11 DP         Allow result copy quoting configuration to be set explicitly rather than using the
resultexport settings [Magnus Hagander] 
-    <li>2006-01-09 DP         Add -a and -q command line options to auto connect to a server and open a query window
respectively[Magnus Hagander] 
-    <li>2006-01-09 DP  1.4.2  Honour the copy quoting setting properly in the SQL results pane [Magnus Hagander]
-    <li>2006-01-09 DP         Use Ctrl-A to select all results in the query results pane. [Magnus Hagander]
-    <li>2006-01-09 DP  1.4.2  Set the initial Unicode/Local charset options correctly in the Export dialogue [Magnus
Hagander]
+    <li>2006-01-11 MH         Allow result copy quoting configuration to be set explicitly rather than using the
resultexport settings 
+    <li>2006-01-09 MH         Add -a and -q command line options to auto connect to a server and open a query window
respectively
+    <li>2006-01-09 MH  1.4.2  Honour the copy quoting setting properly in the SQL results pane
+    <li>2006-01-09 MH         Use Ctrl-A to select all results in the query results pane.
+    <li>2006-01-09 MH  1.4.2  Set the initial Unicode/Local charset options correctly in the Export dialogue
     <li>2005-12-26 AP  1.4.2  Fix PK detection in EditGrid per Andrus Moor
     <li>2005-12-26 AP  1.4.2  Fix Bitmap Index explain per Alexander Kirpa
     <li>2005-12-23 DP  1.4.2  Use ELSIF not ELSEIF in pgagent.sql for compatibility with 7.x servers [Glen Sasek]

Modified: trunk/pgadmin3/docs/en_US/status.html
===================================================================
--- trunk/pgadmin3/docs/en_US/status.html    2006-01-19 12:31:41 UTC (rev 4931)
+++ trunk/pgadmin3/docs/en_US/status.html    2006-01-19 13:49:47 UTC (rev 4932)
@@ -14,7 +14,8 @@

 <p>
 The Server Status dialogue displays the current connections to each
-database, the user that is connected, the process ID, the current
+database, the user that is connected, the process ID, the client address
+and start time (on PostgreSQL 8.1 and above), the current
 query being executed (if any), and the query start time (where appropriate)
 on PostgreSQL 7.4 and above on the Status tab.
 </p>

Modified: trunk/pgadmin3/src/frm/frmStatus.cpp
===================================================================
--- trunk/pgadmin3/src/frm/frmStatus.cpp    2006-01-19 12:31:41 UTC (rev 4931)
+++ trunk/pgadmin3/src/frm/frmStatus.cpp    2006-01-19 13:49:47 UTC (rev 4932)
@@ -110,10 +110,13 @@
     statusList->AddColumn(_("Database"), 70);
     statusList->AddColumn(_("User"), 70);
     if (connection->BackendMinimumVersion(8, 1))
+    {
         statusList->AddColumn(_("Client"), 70);
+        statusList->AddColumn(_("Client start"), 80);
+    }

     if (connection->BackendMinimumVersion(7, 4))
-        statusList->AddColumn(_("Start"), 50);
+        statusList->AddColumn(_("Query start"), 50);

     statusList->AddColumn(_("Query"), 500);

@@ -317,6 +320,8 @@
                         if (client == wxT(":-1"))
                             client = _("local pipe");
                         statusList->SetItem(row, colpos++, client);
+
+                        statusList->SetItem(row, colpos++, dataSet1->GetVal(wxT("backend_start")));
                     }
                     if (connection->BackendMinimumVersion(7, 4))
                     {