pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed3 Parameters in pg_settings in CamelCase
2+ messages / 2 participants
[nested] [flat]
* 3 Parameters in pg_settings in CamelCase
@ 2021-01-20 08:56 William Sescu (Suva) <william.sescu@suva.ch>
2021-01-20 11:36 ` Re: 3 Parameters in pg_settings in CamelCase Ian Lawrence Barwick <barwick@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: William Sescu (Suva) @ 2021-01-20 08:56 UTC (permalink / raw)
To: pgsql-admin
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.
Attachments:
smime.p7s (application/pkcs7-signature, 5.7K) download
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 3 Parameters in pg_settings in CamelCase
2021-01-20 08:56 3 Parameters in pg_settings in CamelCase William Sescu (Suva) <william.sescu@suva.ch>
@ 2021-01-20 11:36 ` Ian Lawrence Barwick <barwick@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Ian Lawrence Barwick @ 2021-01-20 11:36 UTC (permalink / raw)
To: William Sescu (Suva) <william.sescu@suva.ch>; +Cc: 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.
[*]
https://git.postgresql.org/pg/commitdiff/f0811a74b37427d7ee5eee56b00f7f2ea323d7d6
Regards
Ian Barwick
--
EnterpriseDB: https://www.enterprisedb.com
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-01-20 11:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-01-20 08:56 3 Parameters in pg_settings in CamelCase William Sescu (Suva) <william.sescu@suva.ch>
2021-01-20 11:36 ` Ian Lawrence Barwick <barwick@gmail.com>
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