pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
is_local parameter on set_config function
4+ messages / 4 participants
[nested] [flat]

Commits from this thread:
  2021-01-29 f743a2bbd4 2a01bc275b  Doc: improve cross-references for SET/SHOW.
* is_local parameter on set_config function
@ 2021-01-28 11:32  PG Doc comments form <noreply@postgresql.org>
  0 siblings, 1 reply; 4+ messages in thread

From: PG Doc comments form @ 2021-01-28 11:32 UTC (permalink / raw)
  To: pgsql-docs@lists.postgresql.org; +Cc: joao.miguel.c.ferreira@gmail.com

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/config-setting.html
Description:

Hello,

I have just used the set_config(...) function for the first time and it took
me a bit of experimenting to understand the effect of the is_local
parameter. My suggestion would be to add a bit of explanation on that.

Thank you
Joao


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: is_local parameter on set_config function
@ 2021-01-29 05:14  Michael Paquier <michael@paquier.xyz>
  parent: PG Doc comments form <noreply@postgresql.org>
  0 siblings, 1 reply; 4+ messages in thread

From: Michael Paquier @ 2021-01-29 05:14 UTC (permalink / raw)
  To: joao.miguel.c.ferreira@gmail.com; pgsql-docs@lists.postgresql.org

On Thu, Jan 28, 2021 at 11:32:42AM +0000, PG Doc comments form wrote:
> I have just used the set_config(...) function for the first time and it took
> me a bit of experimenting to understand the effect of the is_local
> parameter. My suggestion would be to add a bit of explanation on that.

This is equivalent to the LOCAL clause in the SET query:
https://www.postgresql.org/docs/9.5/sql-set.html
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: is_local parameter on set_config function
@ 2021-01-29 05:28  David G. Johnston <david.g.johnston@gmail.com>
  parent: Michael Paquier <michael@paquier.xyz>
  0 siblings, 1 reply; 4+ messages in thread

From: David G. Johnston @ 2021-01-29 05:28 UTC (permalink / raw)
  To: Michael Paquier <michael@paquier.xyz>; +Cc: joao.miguel.c.ferreira@gmail.com, Pg Docs <pgsql-docs@lists.postgresql.org>

On Thu, Jan 28, 2021 at 10:14 PM Michael Paquier <michael@paquier.xyz>
wrote:

> On Thu, Jan 28, 2021 at 11:32:42AM +0000, PG Doc comments form wrote:
> > I have just used the set_config(...) function for the first time and it
> took
> > me a bit of experimenting to understand the effect of the is_local
> > parameter. My suggestion would be to add a bit of explanation on that.
>
> This is equivalent to the LOCAL clause in the SET query:
> https://www.postgresql.org/docs/9.5/sql-set.html
>
>
Specifically, the hyperlink link to the SET command in that section is
expected to be referenced for details.  Repeating that documentation on the
config-settings page is not particularly desirable.

David J.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: is_local parameter on set_config function
@ 2021-01-29 15:10  Tom Lane <tgl@sss.pgh.pa.us>
  parent: David G. Johnston <david.g.johnston@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Tom Lane @ 2021-01-29 15:10 UTC (permalink / raw)
  To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Michael Paquier <michael@paquier.xyz>; joao.miguel.c.ferreira@gmail.com, Pg Docs <pgsql-docs@lists.postgresql.org>

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thu, Jan 28, 2021 at 10:14 PM Michael Paquier <michael@paquier.xyz>
> wrote:
>> This is equivalent to the LOCAL clause in the SET query:
>> https://www.postgresql.org/docs/9.5/sql-set.html

> Specifically, the hyperlink link to the SET command in that section is
> expected to be referenced for details.  Repeating that documentation on the
> config-settings page is not particularly desirable.

I think the OP might be looking at table 9.85 (Configuration Settings
Functions), in which the cross-references to SET and SHOW are *not*
hyperlinks.  But they should be.  Will fix.  I think there might be
room to say explicitly that is_local is equivalent to SET's LOCAL
option, too.

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2021-01-29 15:10 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-01-28 11:32 is_local parameter on set_config function PG Doc comments form <noreply@postgresql.org>
2021-01-29 05:14 ` Michael Paquier <michael@paquier.xyz>
2021-01-29 05:28   ` David G. Johnston <david.g.johnston@gmail.com>
2021-01-29 15:10     ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox