SVN Commit by dpage: r4175 - in trunk/pgadmin3: . src/schema

Author: dpage
Date: 2005-05-10 20:41:08 +0100 (Tue, 10 May 2005)
New Revision: 4175

Modified:
   trunk/pgadmin3/CHANGELOG.txt
   trunk/pgadmin3/src/schema/pgIndex.cpp
Log:
Display comments on contraints properly [Hiroshi Saito]

Modified: trunk/pgadmin3/CHANGELOG.txt
===================================================================
--- trunk/pgadmin3/CHANGELOG.txt    2005-05-10 07:16:38 UTC (rev 4174)
+++ trunk/pgadmin3/CHANGELOG.txt    2005-05-10 19:41:08 UTC (rev 4175)
@@ -17,6 +17,9 @@
 </ul>
 <br>
 <ul>
+    <li>2005-05-10 HS  1.2.2 Display comments on contraints properly
+    <li>2005-05-08 DP        Major source code reshuffle
+    <li>2005-05-08 DP        Overhaul *nix automake build system
     <li>2005-03-25 DP        Mac OSX support [Florian G. Pflug]
     <li>2005-04-22 AP        more Hint enhancements
     <li>2005-04-19 AP        Hint enhancements

Modified: trunk/pgadmin3/src/schema/pgIndex.cpp
===================================================================
--- trunk/pgadmin3/src/schema/pgIndex.cpp    2005-05-10 07:16:38 UTC (rev 4174)
+++ trunk/pgadmin3/src/schema/pgIndex.cpp    2005-05-10 19:41:08 UTC (rev 4175)
@@ -273,7 +273,7 @@
         wxT("  JOIN pg_am am ON am.oid=cls.relam\n")
         wxT("  LEFT JOIN pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid = cls.oid AND dep.refobjsubid =
'0')\n")
         wxT("  LEFT OUTER JOIN pg_constraint con ON (con.tableoid = dep.refclassid AND con.oid = dep.refobjid)\n")
-        wxT("  LEFT OUTER JOIN pg_description des ON des.objoid=cls.oid\n")
+        wxT("  LEFT OUTER JOIN pg_description des ON des.objoid=con.oid\n")
         wxT("  LEFT OUTER JOIN pg_description desp ON (desp.objoid=con.oid AND desp.objsubid = 0)\n")
         wxT(" WHERE indrelid = ") + collection->GetOidStr()
         + restriction + wxT("\n")