From 14f158835618216cf0ef9bc8862ecb1b3fe09d90 Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Tue, 16 Jul 2002 17:48:46 +0000
Subject: [PATCH] Add initdb code to set up initial contents of pg_depend,
 pinning all objects created during initdb (except for the system views, which
 I think do not need to be pinned).

---
 src/bin/initdb/initdb.sh | 29 ++++++++++++++++++++++++++++-
 1 file changed, 28 insertions(+), 1 deletion(-)

diff --git a/src/bin/initdb/initdb.sh b/src/bin/initdb/initdb.sh
index 144dad4dba..9948bcd7fe 100644
--- a/src/bin/initdb/initdb.sh
+++ b/src/bin/initdb/initdb.sh
@@ -27,7 +27,7 @@
 # Portions Copyright (c) 1996-2002, 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.157 2002/07/12 18:43:18 tgl Exp $
+# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.158 2002/07/16 17:48:46 tgl Exp $
 #
 #-------------------------------------------------------------------------
 
@@ -697,6 +697,33 @@ fi
 echo "ok"
 
 
+$ECHO_N "initializing pg_depend... "$ECHO_C
+
+"$PGPATH"/postgres $PGSQL_OPT template1 >/dev/null <<EOF
+-- Make PIN entries in pg_depend for all objects made so far in the tables
+-- that the dependency code handles.  This is overkill (the system doesn't
+-- really depend on having every last weird datatype, for instance)
+-- but generating only the minimum required set of dependencies seems hard.
+-- Note that we deliberately do not pin the system views.
+-- First delete any already-made entries; PINs override all else, and must
+-- be the only entries for their objects.
+DELETE FROM pg_depend;
+INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_class;
+INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_proc;
+INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_type;
+INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_constraint;
+INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_attrdef;
+INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_language;
+INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_operator;
+INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_rewrite;
+INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_trigger;
+EOF
+if [ "$?" -ne 0 ]; then
+    exit_nicely
+fi
+echo "ok"
+
+
 $ECHO_N "creating system views... "$ECHO_C
 
 "$PGPATH"/postgres $PGSQL_OPT template1 >/dev/null <<EOF
-- 
2.40.0