CVS Commit by andreas: fix dependency display for tablespaces and users

[cvs(at)cvs(dot)pgadmin(dot)org]

Log Message:
-----------
fix dependency display for tablespaces and users

Modified Files:
--------------
    pgadmin3/src/schema:
        pgTablespace.cpp (r1.5 -> r1.6)
        pgUser.cpp (r1.35 -> r1.36)

Index: pgUser.cpp
===================================================================
RCS file: /projects/pgadmin3/src/schema/pgUser.cpp,v
retrieving revision 1.35
retrieving revision 1.36
diff -Lsrc/schema/pgUser.cpp -Lsrc/schema/pgUser.cpp -u -w -r1.35 -r1.36
--- src/schema/pgUser.cpp
+++ src/schema/pgUser.cpp
@@ -133,12 +133,12 @@
     }
 
     FillOwned(form->GetBrowser(), referencedBy, dblist, 
-        wxT("SELECT cl.relkind, COALESCE(cin.nspname, cln.nspname) as nspname, COALESCE(ci.relname, cl.relname) as relname, ci.relname as indname\n")
+        wxT("SELECT cl.relkind, COALESCE(cin.nspname, cln.nspname) as nspname, COALESCE(ci.relname, cl.relname) as relname, cl.relname as indname\n")
         wxT("  FROM pg_class cl\n")
         wxT("  JOIN pg_namespace cln ON cl.relnamespace=cln.oid\n")
         wxT("  LEFT OUTER JOIN pg_index ind ON ind.indexrelid=cl.oid\n")
         wxT("  LEFT OUTER JOIN pg_class ci ON ind.indrelid=ci.oid\n")
-        wxT("  JOIN pg_namespace cin ON ci.relnamespace=cin.oid\n")
+        wxT("  LEFT OUTER JOIN pg_namespace cin ON ci.relnamespace=cin.oid\n")
         wxT(" WHERE cl.relowner = ") + uid + wxT(" AND cl.oid > ") + sysoid + wxT("\n")
         wxT("UNION ALL\n")
         wxT("SELECT 'n', null, nspname, null\n")
Index: pgTablespace.cpp
===================================================================
RCS file: /projects/pgadmin3/src/schema/pgTablespace.cpp,v
retrieving revision 1.5
retrieving revision 1.6
diff -Lsrc/schema/pgTablespace.cpp -Lsrc/schema/pgTablespace.cpp -u -w -r1.5 -r1.6
--- src/schema/pgTablespace.cpp
+++ src/schema/pgTablespace.cpp
@@ -78,12 +78,12 @@
     }
 
     FillOwned(form->GetBrowser(), referencedBy, dblist, 
-        wxT("SELECT cl.relkind, COALESCE(cin.nspname, cln.nspname) as nspname, COALESCE(ci.relname, cl.relname) as relname, ci.relname as indname\n")
+        wxT("SELECT cl.relkind, COALESCE(cin.nspname, cln.nspname) as nspname, COALESCE(ci.relname, cl.relname) as relname, cl.relname as indname\n")
         wxT("  FROM pg_class cl\n")
         wxT("  JOIN pg_namespace cln ON cl.relnamespace=cln.oid\n")
         wxT("  LEFT OUTER JOIN pg_index ind ON ind.indexrelid=cl.oid\n")
         wxT("  LEFT OUTER JOIN pg_class ci ON ind.indrelid=ci.oid\n")
-        wxT("  JOIN pg_namespace cin ON ci.relnamespace=cin.oid\n")
+        wxT("  LEFT OUTER JOIN pg_namespace cin ON ci.relnamespace=cin.oid\n")
         wxT(" WHERE cl.reltablespace IN (") + tsoid + wxT(")\n")
         wxT("UNION ALL\n")
         wxT("SELECT 'n', null, nspname, null\n")