NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitba33775

committed

Restore initdb's old behavior of always setting the lc_xxx GUCs.

In commit3e51b27 I (tgl) caused initdb to leave lc_messages andother lc_xxx GUCs commented-out in the installed postgresql.conf fileif they were going to be set to 'C'. This was a hack for cosmeticpurposes, and it was buggy because lc_messages' wired-in default isnot 'C' but '' (empty string). That led to --no-locale not havingthe expected effect, since the postmaster would then obtainlc_messages from its startup environment.Let's just revert to the prior behavior of always de-commenting thelc_xxx entries; the argument for changing that longstanding behaviorwas weak in the first place.Also, fix postgresql.conf.sample's erroneous claim that the defaultvalue of lc_messages is 'C'. I suspect that was what misled me intomaking this mistake in the first place.Report and patch by Kyotaro Horiguchi. Back-patch to v16 wherethe problem was introduced.Discussion:https://postgr.es/m/20231122.162700.1995154567625541112.horikyota.ntt@gmail.com

1 parentee95532 commitba33775Copy full SHA for ba33775

File tree

2 files changed

-17

lines changed

src
- backend/utils/misc
  - postgresql.conf.sample
- bin/initdb
  - initdb.c

2 files changed

-17

lines changed

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

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -728,7 +728,7 @@`
`728`	`728`	`# encoding`
`729`	`729`
`730`	`730`	`# These settings are initialized by initdb, but they can be changed.`
`731`		`-#lc_messages = 'C'# locale for system error message`
	`731`	`+#lc_messages = ''# locale for system error message`
`732`	`732`	`# strings`
`733`	`733`	`#lc_monetary = 'C'# locale for monetary formatting`
`734`	`734`	`#lc_numeric = 'C'# locale for number formatting`

`‎src/bin/initdb/initdb.c‎`

Lines changed: 8 additions & 16 deletions

Original file line number	Diff line number	Diff line change
`@@ -1223,25 +1223,17 @@ setup_config(void)`
`1223`	`1223`	`conflines=replace_guc_value(conflines,"shared_buffers",`
`1224`	`1224`	`repltok, false);`
`1225`	`1225`
`1226`		`-/*`
`1227`		`- * Hack: don't replace the LC_XXX GUCs when their value is 'C', because`
`1228`		`- * replace_guc_value will decide not to quote that, which looks strange.`
`1229`		`- */`
`1230`		`-if (strcmp(lc_messages,"C")!=0)`
`1231`		`-conflines=replace_guc_value(conflines,"lc_messages",`
`1232`		`-lc_messages, false);`
	`1226`	`+conflines=replace_guc_value(conflines,"lc_messages",`
	`1227`	`+lc_messages, false);`
`1233`	`1228`
`1234`		`-if (strcmp(lc_monetary,"C")!=0)`
`1235`		`-conflines=replace_guc_value(conflines,"lc_monetary",`
`1236`		`-lc_monetary, false);`
	`1229`	`+conflines=replace_guc_value(conflines,"lc_monetary",`
	`1230`	`+lc_monetary, false);`
`1237`	`1231`
`1238`		`-if (strcmp(lc_numeric,"C")!=0)`
`1239`		`-conflines=replace_guc_value(conflines,"lc_numeric",`
`1240`		`-lc_numeric, false);`
	`1232`	`+conflines=replace_guc_value(conflines,"lc_numeric",`
	`1233`	`+lc_numeric, false);`
`1241`	`1234`
`1242`		`-if (strcmp(lc_time,"C")!=0)`
`1243`		`-conflines=replace_guc_value(conflines,"lc_time",`
`1244`		`-lc_time, false);`
	`1235`	`+conflines=replace_guc_value(conflines,"lc_time",`
	`1236`	`+lc_time, false);`
`1245`	`1237`
`1246`	`1238`	`switch (locale_date_order(lc_time))`
`1247`	`1239`	`{`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitba33775

File tree

2 files changed

2 files changed

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

`‎src/bin/initdb/initdb.c‎`

0 commit comments