Commitef60de6

committed

doc: Add note about pg_settings and customized options into catalogs.sgml.

The pg_settings view does not display customized options untilthe extension module that defines them has been loaded. This commitadd the note about that behavior, into the docs.Author: John NaylorReviewed-by: Tom Lane, Fujii MasaoDiscussion:https://postgr.es/m/CAFBsxsGsBZsG=cLM0Op5HFb2Ks6SzJrOc_eRO_jcKSNuqFRKnQ@mail.gmail.com

1 parent3636efa commitef60de6Copy full SHA for ef60de6

File tree

-4

lines changed

-4

lines changed

Lines changed: 8 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -12279,10 +12279,14 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx`
`12279`	`12279`	`</para>`
`12280`	`12280`
`12281`	`12281`	`<para>`
`12282`		`- The <structname>pg_settings</structname> view cannot be inserted into or`
`12283`		`- deleted from, but it can be updated. An <command>UPDATE</command> applied`
`12284`		`- to a row of <structname>pg_settings</structname> is equivalent to executing`
`12285`		`- the <command>SET</command> command on that named`
	`12282`	`+ This view does not display <link linkend="runtime-config-custom">customized options</link>`
	`12283`	`+ until the extension module that defines them has been loaded.`
	`12284`	`+ </para>`
	`12285`	`+`
	`12286`	`+ <para>`
	`12287`	`+ This view cannot be inserted into or deleted from, but it can be updated. An`
	`12288`	`+ <command>UPDATE</command> applied to a row of <structname>pg_settings</structname>`
	`12289`	`+ is equivalent to executing the <command>SET</command> command on that named`
`12286`	`12290`	`parameter. The change only affects the value used by the current`
`12287`	`12291`	`session. If an <command>UPDATE</command> is issued within a transaction`
`12288`	`12292`	`that is later aborted, the effects of the <command>UPDATE</command> command`

Comments

(0)