Enable pg_rewrite to be toasted (unlimited size of views and rules).

Jan Wieck · Jan Wieck · commit 98fe6703607b · 2000-07-05T19:51:03.000Z
Jan
diff --git a/src/bin/initdb/initdb.sh b/src/bin/initdb/initdb.sh
@@ -26,7 +26,7 @@
 #
 #
 # IDENTIFICATION
-#    $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.99 2000/07/03 20:48:46 petere Exp $
+#    $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.100 2000/07/05 19:51:03 wieck Exp $
 #
 #-------------------------------------------------------------------------
 
@@ -534,6 +534,11 @@ if [ "$PwPrompt" ]; then
 fi
 
 
+echo "Enabling unlimited storage for pg_rewrite"
+echo "ALTER TABLE pg_rewrite CREATE TOAST TABLE" \
+        | "$PGPATH"/postgres $PGSQL_OPT template1 > /dev/null || exit_nicely
+
+
 echo "Creating view pg_user."
 echo "CREATE VIEW pg_user AS \
         SELECT \

Original file line number	Diff line number	Diff line change
`@@ -26,7 +26,7 @@`
`26`	`26`	`#`
`27`	`27`	`#`
`28`	`28`	`# IDENTIFICATION`
`29`		`-# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.99 2000/07/03 20:48:46 petere Exp $`
	`29`	`+# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.100 2000/07/05 19:51:03 wieck Exp $`
`30`	`30`	`#`
`31`	`31`	`#-------------------------------------------------------------------------`
`32`	`32`
`@@ -534,6 +534,11 @@ if [ "$PwPrompt" ]; then`
`534`	`534`	`fi`
`535`	`535`
`536`	`536`
	`537`	`+echo "Enabling unlimited storage for pg_rewrite"`
	`538`	`+echo "ALTER TABLE pg_rewrite CREATE TOAST TABLE" \`
	`539`	`+ \| "$PGPATH"/postgres $PGSQL_OPT template1 > /dev/null \|\| exit_nicely`
	`540`	`+`
	`541`	`+`
`537`	`542`	`echo "Creating view pg_user."`
`538`	`543`	`echo "CREATE VIEW pg_user AS \`
`539`	`544`	`SELECT \`