Обсуждение: 3 Parameters in pg_settings in CamelCase

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

3 Parameters in pg_settings in CamelCase

От
"William Sescu (Suva)"
Дата:

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'

 

 

Cheers

William




Disclaimer:

Diese Nachricht und ihr eventuell angehängte Dateien sind nur für den Adressaten bestimmt. Sie kann vertrauliche oder gesetzlich geschützte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrtümlich erreicht hat, bitten wir Sie höflich, diese unter Ausschluss jeglicher Reproduktion zu löschen und die absendende Person zu benachrichtigen. Danke für Ihre Hilfe.

This message and any attached files are for the sole use of the recipient named above. It may contain confidential or legally protected data or information. If you have received this message in error, please delete it without making any copies whatsoever and notify the sender. Thank you for your assistance.
Вложения

Re: 3 Parameters in pg_settings in CamelCase

От
Ian Lawrence Barwick
Дата:


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

--