NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit139d46e

committed

Further tweak the default behavior of psql's \dconfig.

Define "parameters with non-default settings" as being those thatnot only have pg_settings.source different from 'default', butalso have a current value different from the hard-wired boot_val.Adding the latter restriction removes a number of not-very-interestingcases where the active setting is chosen by initdb but in practicetends to be the same all the time.Per discussion with Jonathan Katz.Discussion:https://postgr.es/m/YlFQLzlPi4QD0wSi@msg.df7cb.de

1 parent7b7ed04 commit139d46eCopy full SHA for 139d46e

File tree

1 file changed

-1

lines changed

src/bin/psql
- describe.c

1 file changed

-1

lines changed

`‎src/bin/psql/describe.c‎`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -4408,7 +4408,8 @@ describeConfigurationParameters(const char *pattern, bool verbose,`
`4408`	`4408`	`NULL,"pg_catalog.lower(s.name)",NULL,`
`4409`	`4409`	`NULL);`
`4410`	`4410`	`else`
`4411`		`-appendPQExpBufferStr(&buf,"WHERE s.source <> 'default'\n");`
	`4411`	`+appendPQExpBufferStr(&buf,"WHERE s.source <> 'default' AND\n"`
	`4412`	`+" s.setting IS DISTINCT FROM s.boot_val\n");`
`4412`	`4413`
`4413`	`4414`	`appendPQExpBufferStr(&buf,"ORDER BY 1;");`
`4414`	`4415`

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!

Commit139d46e

File tree

1 file changed

1 file changed

`‎src/bin/psql/describe.c‎`

0 commit comments