Commit8cb041a

committed

Set up the privileges on the default schemas in initdb with real GRANT

commands, to arrive at a valid and dumpable state.

1 parent28efaf3 commit8cb041aCopy full SHA for 8cb041a

File tree

+10

-8

lines changed

+10

-8

lines changed

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -27,7 +27,7 @@`
`27`	`27`	`# Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group`
`28`	`28`	`# Portions Copyright (c) 1994, Regents of the University of California`
`29`	`29`	`#`
`30`		`-# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.184 2003/02/1923:41:15 momjian Exp $`
	`30`	`+# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.185 2003/03/1916:08:59 petere Exp $`
`31`	`31`	`#`
`32`	`32`	`#-------------------------------------------------------------------------`
`33`	`33`
`@@ -1035,6 +1035,8 @@ $ECHO_N "setting privileges on built-in objects... "$ECHO_C`
`1035`	`1035`	`WHERE proacl IS NULL;`
`1036`	`1036`	`UPDATE pg_language SET lanacl = '{"=U/$POSTGRES_SUPERUSERNAME"}'\`
`1037`	`1037`	`WHERE lanpltrusted;`
	`1038`	`+ GRANT USAGE ON SCHEMA pg_catalog TO PUBLIC;`
	`1039`	`+ GRANT CREATE, USAGE ON SCHEMA public TO PUBLIC;`
`1038`	`1040`	`EOF`
`1039`	`1041`	`) \`
`1040`	`1042`	`\|"$PGPATH"/postgres$PGSQL_OPT template1> /dev/null\|\| exit_nicely`

Lines changed: 7 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`* Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group`
`9`	`9`	`* Portions Copyright (c) 1994, Regents of the University of California`
`10`	`10`	`*`
`11`		`- * $Id: pg_namespace.h,v 1.8 2002/09/04 20:31:37 momjian Exp $`
	`11`	`+ * $Id: pg_namespace.h,v 1.9 2003/03/19 16:08:59 petere Exp $`
`12`	`12`	`*`
`13`	`13`	`* NOTES`
`14`	`14`	`* the genbki.sh script reads this file and generates .bki`
`@@ -66,14 +66,14 @@ typedef FormData_pg_namespace *Form_pg_namespace;`
`66`	`66`	`* ---------------`
`67`	`67`	`*/`
`68`	`68`
`69`		`-DATA(insertOID=11 ("pg_catalog"PGUID"{=U}" ));`
`70`		`-DESCR("System catalognamespace");`
	`69`	`+DATA(insertOID=11 ("pg_catalog"PGUID_null_ ));`
	`70`	`+DESCR("System catalogschema");`
`71`	`71`	`#definePG_CATALOG_NAMESPACE 11`
`72`		`-DATA(insertOID=99 ("pg_toast"PGUID"{=}" ));`
`73`		`-DESCR("Reservednamespace for TOAST tables");`
	`72`	`+DATA(insertOID=99 ("pg_toast"PGUID_null_ ));`
	`73`	`+DESCR("Reservedschema for TOAST tables");`
`74`	`74`	`#definePG_TOAST_NAMESPACE 99`
`75`		`-DATA(insertOID=2200 ("public"PGUID"{=UC}" ));`
`76`		`-DESCR("Standard publicnamespace");`
	`75`	`+DATA(insertOID=2200 ("public"PGUID_null_ ));`
	`76`	`+DESCR("Standard publicschema");`
`77`	`77`	`#definePG_PUBLIC_NAMESPACE 2200`
`78`	`78`
`79`	`79`

Comments

(0)