Forgot that dumpall's output script should 'delete from pg_group' before

tglsfdc · tglsfdc · commit b45f3a6e5bec · 2000-05-05T17:50:38.000Z
loading new data, for consistency with its handling of pg_shadow.
diff --git a/src/bin/pg_dump/pg_dumpall b/src/bin/pg_dump/pg_dumpall
@@ -5,7 +5,7 @@
 # It also dumps the pg_shadow and pg_group tables, which belong to the
 # whole installation rather than any one individual database.
 #
-# $Header: /cvsroot/pgsql/src/bin/pg_dump/Attic/pg_dumpall,v 1.25 2000/05/05 03:04:00 tgl Exp $
+# $Header: /cvsroot/pgsql/src/bin/pg_dump/Attic/pg_dumpall,v 1.26 2000/05/05 17:50:38 tgl Exp $
 #
 # to adapt to System V vs. BSD 'echo'
 if echo '\\' | grep '\\\\' >/dev/null 2>&1
@@ -56,6 +56,7 @@ echo "${BS}."
 # XXX this breaks badly if the layout of pg_group ever changes.
 # It'd be better to convert the data into CREATE GROUP commands.
 #
+echo "delete from pg_group;"
 echo "copy pg_group from stdin;"
 psql -q template1 <<END
 copy pg_group to stdout;

Original file line number	Diff line number	Diff line change
`@@ -5,7 +5,7 @@`
`5`	`5`	`# It also dumps the pg_shadow and pg_group tables, which belong to the`
`6`	`6`	`# whole installation rather than any one individual database.`
`7`	`7`	`#`
`8`		`-# $Header: /cvsroot/pgsql/src/bin/pg_dump/Attic/pg_dumpall,v 1.25 2000/05/05 03:04:00 tgl Exp $`
	`8`	`+# $Header: /cvsroot/pgsql/src/bin/pg_dump/Attic/pg_dumpall,v 1.26 2000/05/05 17:50:38 tgl Exp $`
`9`	`9`	`#`
`10`	`10`	`# to adapt to System V vs. BSD 'echo'`
`11`	`11`	`if echo '\\' \| grep '\\\\' >/dev/null 2>&1`
`@@ -56,6 +56,7 @@ echo "${BS}."`
`56`	`56`	`# XXX this breaks badly if the layout of pg_group ever changes.`
`57`	`57`	`# It'd be better to convert the data into CREATE GROUP commands.`
`58`	`58`	`#`
	`59`	`+echo "delete from pg_group;"`
`59`	`60`	`echo "copy pg_group from stdin;"`
`60`	`61`	`psql -q template1 <<END`
`61`	`62`	`copy pg_group to stdout;`