(unnamed)

text/plain

Filename: (unnamed)
Type: text/plain
Part: 0
Message: Re: Disparity in search_path SHOW and SET
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'
  </programlisting>
      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'
  </programlisting>
      One parameter is specified per line. The equal sign between name and
      value is optional. Whitespace is insignificant and blank lines are
***************
*** 3117,3123 ****
  
         <para>
          The default value for this parameter is
!         <literal>'$user, public'</literal> (where the second part will be
          ignored if there is no schema named <literal>public</>).
          This supports shared use of a database (where no users
          have private schemas, and all share use of <literal>public</>),
--- 3117,3123 ----
  
         <para>
          The default value for this parameter is
!         <literal>'"$user", public'</literal> (where the second part will be
          ignored if there is no schema named <literal>public</>).
          This supports shared use of a database (where no users
          have private schemas, and all share use of <literal>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 ****
  <screen>
   search_path
  --------------
!  $user,public
  </screen>
      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 ----
  <screen>
   search_path
  --------------
!  "$user",public
  </screen>
      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