Обсуждение: is_local parameter on set_config function

Поиск
Список
Период
Сортировка

is_local parameter on set_config function

От
PG Doc comments form
Дата:
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

Re: is_local parameter on set_config function

От
Michael Paquier
Дата:
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

Вложения

Re: is_local parameter on set_config function

От
"David G. Johnston"
Дата:
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.

Re: is_local parameter on set_config function

От
Tom Lane
Дата:
"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