Re: current_setting returns 'unset'

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: current_setting returns 'unset'
Дата
Msg-id 43C3D182.30207@joeconway.com
обсуждение исходный текст
Ответ на current_setting returns 'unset'  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Peter Eisentraut wrote:
> The function current_setting returns 'unset' if a parameter is not 
> set.

> This is not documented,

It is documented to produce equivalent output as the sql SHOW command. 
Although the reference page for SHOW does not specifically address 
parameters that are not set, it does have one in the example at the bottom.

> so I guess this just arose out of the implementation, or is this intentional?

The implementation was based on infrastructure already existing for
SHOW, so this is an artifact of that implementation. In the case of a 
string variable, _ShowOption() returns "unset" when a parameter is not 
set, and that gets passed all the way back.

Joe



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: lookup_rowtype_tupdesc considered harmful
Следующее
От: Tony Caduto
Дата:
Сообщение: Question about Postgresql time fields(possible bug)