Commite80f9df

committed

Add quotes around search_path "$user" so that SHOW output can be used in

SET.

1 parent2f1a78e commite80f9dfCopy full SHA for e80f9df

File tree

-8

lines changed

-8

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.39 2005/12/20 02:30:35 tgl Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.40 2005/12/23 00:38:03 momjian Exp $`
`3`	`3`	`-->`
`4`	`4`	`<chapter Id="runtime-config">`
`5`	`5`	`<title>Server Configuration</title>`
`@@ -39,7 +39,7 @@ $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.39 2005/12/20 02:30:35 tgl Exp $`
`39`	`39`	`# This is a comment`
`40`	`40`	`log_connections = yes`
`41`	`41`	`log_destination = 'syslog'`
`42`		`-search_path = '$user, public'`
	`42`	`+search_path = '"$user", public'`
`43`	`43`	`</programlisting>`
`44`	`44`	`One parameter is specified per line. The equal sign between name and`
`45`	`45`	`value is optional. Whitespace is insignificant and blank lines are`
`@@ -3117,7 +3117,7 @@ SELECT * FROM parent WHERE key = 2400;`
`3117`	`3117`
`3118`	`3118`	`<para>`
`3119`	`3119`	`The default value for this parameter is`
`3120`		`- <literal>'$user, public'</literal> (where the second part will be`
	`3120`	`+ <literal>'"$user", public'</literal> (where the second part will be`
`3121`	`3121`	`ignored if there is no schema named <literal>public</>).`
`3122`	`3122`	`This supports shared use of a database (where no users`
`3123`	`3123`	`have private schemas, and all share use of <literal>public</>),`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.50 2005/11/04 23:53:18 tgl Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.51 2005/12/23 00:38:03 momjian Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="ddl">`
`4`	`4`	`<title>Data Definition</title>`
`@@ -1650,7 +1650,7 @@ SHOW search_path;`
`1650`	`1650`	`<screen>`
`1651`	`1651`	`search_path`
`1652`	`1652`	`--------------`
`1653`		`- $user,public`
	`1653`	`+"$user",public`
`1654`	`1654`	`</screen>`
`1655`	`1655`	`The first element specifies that a schema with the same name as`
`1656`	`1656`	`the current user is to be searched. If no such schema exists,`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -10,7 +10,7 @@`
`10`	`10`	`* Written by Peter Eisentraut <peter_e@gmx.net>.`
`11`	`11`	`*`
`12`	`12`	`* IDENTIFICATION`
`13`		`- * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.302 2005/12/20 02:30:36 tgl Exp $`
	`13`	`+ * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.303 2005/12/23 00:38:04 momjian Exp $`
`14`	`14`	`*`
`15`	`15`	`*--------------------------------------------------------------------`
`16`	`16`	`*/`
`@@ -1902,7 +1902,7 @@ static struct config_string ConfigureNamesString[] =`
`1902`	`1902`	`GUC_LIST_INPUT \|GUC_LIST_QUOTE`
`1903`	`1903`	`},`
`1904`	`1904`	`&namespace_search_path,`
`1905`		`-"$user,public",assign_search_path,NULL`
	`1905`	`+"\"$user\",public",assign_search_path,NULL`
`1906`	`1906`	`},`
`1907`	`1907`
`1908`	`1908`	`{`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -364,7 +364,7 @@`
`364`	`364`
`365`	`365`	`# - Statement Behavior -`
`366`	`366`
`367`		`-#search_path = '$user,public'# schema names`
	`367`	`+#search_path = '"$user",public'# schema names`
`368`	`368`	`#default_tablespace = ''# a tablespace name, '' uses`
`369`	`369`	`# the default`
`370`	`370`	`#check_function_bodies = on`

Comments

(0)