Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit02587dc

Browse files
committed
Use comma+space as the separator in the default search_path.
While the space is optional, it seems nicer to be consistent with whatyou get if you do "SET search_path=...". SET always normalizes theseparator to be comma+space.Christoph Martin
1 parentc476288 commit02587dc

File tree

3 files changed

+3
-3
lines changed

3 files changed

+3
-3
lines changed

‎doc/src/sgml/ddl.sgml‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1746,7 +1746,7 @@ SHOW search_path;
17461746
<screen>
17471747
search_path
17481748
--------------
1749-
"$user",public
1749+
"$user",public
17501750
</screen>
17511751
The first element specifies that a schema with the same name as
17521752
the current user is to be searched. If no such schema exists,

‎src/backend/utils/misc/guc.c‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2912,7 +2912,7 @@ static struct config_string ConfigureNamesString[] =
29122912
GUC_LIST_INPUT |GUC_LIST_QUOTE
29132913
},
29142914
&namespace_search_path,
2915-
"\"$user\",public",
2915+
"\"$user\",public",
29162916
check_search_path,assign_search_path,NULL
29172917
},
29182918

‎src/backend/utils/misc/postgresql.conf.sample‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -499,7 +499,7 @@
499499

500500
# - Statement Behavior -
501501

502-
#search_path = '"$user",public'# schema names
502+
#search_path = '"$user",public'# schema names
503503
#default_tablespace = ''# a tablespace name, '' uses the default
504504
#temp_tablespaces = ''# a list of tablespace names, '' uses
505505
# only default tablespace

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp