Re: 3 Parameters in pg_settings in CamelCase

Поиск
Список
Период
Сортировка
От Ian Lawrence Barwick
Тема Re: 3 Parameters in pg_settings in CamelCase
Дата
Msg-id CAB8KJ=hDsqCfR+aMfzNyO3i+ARozKJF8DC=1XzoWeDL73vqcQw@mail.gmail.com
обсуждение исходный текст
Ответ на 3 Parameters in pg_settings in CamelCase  ("William Sescu (Suva)" <william.sescu@suva.ch>)
Список pgsql-admin


2021年1月20日(水) 17:56 William Sescu (Suva) <william.sescu@suva.ch>:

Hello %

 

Is there any particular reason why 3 parameters out of 326 (in PostgreSQL 12.4) are in CamelCase?

At least when you query from pg_settings.

 

(postgres@[local]:55000)[postgres]> select name from pg_settings order by name;

                  name

----------------------------------------

DateStyle

IntervalStyle

TimeZone

 

All others are in lowercase. Even in the postgresql.conf these parameters are in lowercase.

 

$ cat postgresql.conf | egrep -i '(datestyle|intervalstyle|timezone)'

datestyle = 'iso, mdy'

#intervalstyle = 'postgres'

timezone = 'Europe/Zurich'


I think the simple answer is "because they've always been like that" (at least since PostgreSQL 7.3 [*])
and no-one has cared enough to change them.


Regards

Ian Barwick

--

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

Предыдущее
От:
Дата:
Сообщение: RE: Data Type to store Leading Zero(0)
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Data Type to store Leading Zero(0)