Use LEFT JOIN, not FULL JOIN, in statistical views.

1 files changed, 5 insertions, 5 deletions

diff --git a/src/bin/initdb/initdb.sh b/src/bin/initdb/initdb.sh
index 8f4eb657878..6ec85b30a46 100644
--- a/src/bin/initdb/initdb.sh
+++ b/src/bin/initdb/initdb.sh
@@ -27,7 +27,7 @@
 # Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
 # Portions Copyright (c) 1994, Regents of the University of California
 #
-# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.138 2001/09/30 22:17:50 momjian Exp $
+# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.139 2001/10/16 20:51:35 tgl Exp $
 #
 #-------------------------------------------------------------------------
 
@@ -668,7 +668,7 @@ CREATE VIEW pg_stat_all_tables AS \
             pg_stat_get_tuples_inserted(C.oid) AS n_tup_ins, \
             pg_stat_get_tuples_updated(C.oid) AS n_tup_upd, \
             pg_stat_get_tuples_deleted(C.oid) AS n_tup_del \
-    FROM pg_class C FULL OUTER JOIN \
+    FROM pg_class C LEFT OUTER JOIN \
          pg_index I ON C.oid = I.indrelid \
     WHERE C.relkind = 'r' \
     GROUP BY C.oid, C.relname;
@@ -697,9 +697,9 @@ CREATE VIEW pg_statio_all_tables AS \
             pg_stat_get_blocks_fetched(X.oid) - \
                     pg_stat_get_blocks_hit(X.oid) AS tidx_blks_read, \
             pg_stat_get_blocks_hit(X.oid) AS tidx_blks_hit \
-    FROM pg_class C FULL OUTER JOIN \
-            pg_index I ON C.oid = I.indrelid FULL OUTER JOIN \
-            pg_class T ON C.reltoastrelid = T.oid FULL OUTER JOIN \
+    FROM pg_class C LEFT OUTER JOIN \
+            pg_index I ON C.oid = I.indrelid LEFT OUTER JOIN \
+            pg_class T ON C.reltoastrelid = T.oid LEFT OUTER JOIN \
             pg_class X ON T.reltoastidxid = X.oid \
     WHERE C.relkind = 'r' \
     GROUP BY C.oid, C.relname, T.oid, X.oid;