Index: doc/src/sgml/config.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/config.sgml,v retrieving revision 1.39 diff -c -c -r1.39 config.sgml *** doc/src/sgml/config.sgml 20 Dec 2005 02:30:35 -0000 1.39 --- doc/src/sgml/config.sgml 22 Dec 2005 23:42:13 -0000 *************** *** 39,45 **** # This is a comment log_connections = yes log_destination = 'syslog' ! search_path = '$user, public' One parameter is specified per line. The equal sign between name and value is optional. Whitespace is insignificant and blank lines are --- 39,45 ---- # This is a comment log_connections = yes log_destination = 'syslog' ! search_path = '"$user", public' One parameter is specified per line. The equal sign between name and value is optional. Whitespace is insignificant and blank lines are *************** *** 3117,3123 **** The default value for this parameter is ! '$user, public' (where the second part will be ignored if there is no schema named public). This supports shared use of a database (where no users have private schemas, and all share use of public), --- 3117,3123 ---- The default value for this parameter is ! '"$user", public' (where the second part will be ignored if there is no schema named public). This supports shared use of a database (where no users have private schemas, and all share use of public), Index: doc/src/sgml/ddl.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/ddl.sgml,v retrieving revision 1.50 diff -c -c -r1.50 ddl.sgml *** doc/src/sgml/ddl.sgml 4 Nov 2005 23:53:18 -0000 1.50 --- doc/src/sgml/ddl.sgml 22 Dec 2005 23:42:14 -0000 *************** *** 1650,1656 **** search_path -------------- ! $user,public The first element specifies that a schema with the same name as the current user is to be searched. If no such schema exists, --- 1650,1656 ---- search_path -------------- ! "$user",public The first element specifies that a schema with the same name as the current user is to be searched. If no such schema exists, Index: src/backend/utils/misc/guc.c =================================================================== RCS file: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v retrieving revision 1.302 diff -c -c -r1.302 guc.c *** src/backend/utils/misc/guc.c 20 Dec 2005 02:30:36 -0000 1.302 --- src/backend/utils/misc/guc.c 22 Dec 2005 23:42:17 -0000 *************** *** 1902,1908 **** GUC_LIST_INPUT | GUC_LIST_QUOTE }, &namespace_search_path, ! "$user,public", assign_search_path, NULL }, { --- 1902,1908 ---- GUC_LIST_INPUT | GUC_LIST_QUOTE }, &namespace_search_path, ! "\"$user\",public", assign_search_path, NULL }, { Index: src/backend/utils/misc/postgresql.conf.sample =================================================================== RCS file: /cvsroot/pgsql/src/backend/utils/misc/postgresql.conf.sample,v retrieving revision 1.171 diff -c -c -r1.171 postgresql.conf.sample *** src/backend/utils/misc/postgresql.conf.sample 17 Nov 2005 22:14:54 -0000 1.171 --- src/backend/utils/misc/postgresql.conf.sample 22 Dec 2005 23:42:19 -0000 *************** *** 364,370 **** # - Statement Behavior - ! #search_path = '$user,public' # schema names #default_tablespace = '' # a tablespace name, '' uses # the default #check_function_bodies = on --- 364,370 ---- # - Statement Behavior - ! #search_path = '"$user",public' # schema names #default_tablespace = '' # a tablespace name, '' uses # the default #check_function_bodies = on