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")