Skip site navigation (1) Skip section navigation (2)

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

From: svn(at)pgadmin(dot)org
To: pgadmin-hackers(at)postgresql(dot)org
Subject: SVN Commit by dpage: r4932 - in trunk/pgadmin3: . docs/en_US src/frm
Date: 2006-01-19 13:49:47
Message-ID: 200601191349.k0JDnlIP012618@developer.pgadmin.org (view raw or flat)
Thread:
Lists: 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 result export 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 result export 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))
 					{


pgadmin-hackers by date

Next:From: Dave PageDate: 2006-01-19 13:50:16
Subject: Re: Patch: Show client connect time
Previous:From: Peter EisentrautDate: 2006-01-19 13:34:15
Subject: Menu items beautification

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group