Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l29Hi-0002NZ-SM for pgsql-admin@arkaria.postgresql.org; Wed, 20 Jan 2021 08:56:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l29Hh-0004ry-BF for pgsql-admin@arkaria.postgresql.org; Wed, 20 Jan 2021 08:56:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l29Hg-0004rq-R4 for pgsql-admin@lists.postgresql.org; Wed, 20 Jan 2021 08:56:13 +0000 Received: from mailgw99.suva.ch ([195.65.221.20]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l29Ha-00035T-Pt for pgsql-admin@postgresql.org; Wed, 20 Jan 2021 08:56:11 +0000 From: "William Sescu (Suva)" To: "pgsql-admin@postgresql.org" Subject: 3 Parameters in pg_settings in CamelCase Thread-Topic: 3 Parameters in pg_settings in CamelCase Thread-Index: AdbvCTnaTZpjrlH0RauXHdhB6u96RA== Date: Wed, 20 Jan 2021 08:56:02 +0000 Message-ID: <254bc57bf034482aa0e1357221ce96b6@suva.ch> Accept-Language: en-US, de-CH Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.93.103.203] X-SM-outgoing: yes MIME-Version: 1.0 Content-Type: multipart/signed; protocol="application/pkcs7-signature"; micalg="sha-256"; boundary="----D8DE5AE6C5AE25B746C8B784BAD61A14" X-FE-Attachment-Name: smime.p7s X-FE-Policy-ID: 69:20:1:SYSTEM List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an S/MIME signed message ------D8DE5AE6C5AE25B746C8B784BAD61A14 Content-Type: multipart/alternative; boundary="_000_254bc57bf034482aa0e1357221ce96b6suvach_" MIME-version: 1.0 --_000_254bc57bf034482aa0e1357221ce96b6suvach_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello % Is there any particular reason why 3 parameters out of 326 (in PostgreSQL 1= 2.4) are in CamelCase? At least when you query from pg_settings. (postgres@[local]:55000)[postgres]> select name from pg_settings order by n= ame; name ---------------------------------------- ... ... DateStyle IntervalStyle TimeZone ... ... All others are in lowercase. Even in the postgresql.conf these parameters a= re in lowercase. $ cat postgresql.conf | egrep -i '(datestyle|intervalstyle|timezone)' datestyle =3D 'iso, mdy' #intervalstyle =3D 'postgres' timezone =3D 'Europe/Zurich' Cheers William ________________________________ Disclaimer: Diese Nachricht und ihr eventuell angeh?ngte Dateien sind nur f?r den Adres= saten bestimmt. Sie kann vertrauliche oder gesetzlich gesch?tzte Daten oder= Informationen beinhalten. Falls Sie diese Nachricht irrt?mlich erreicht ha= t, 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 n= amed above. It may contain confidential or legally protected data or inform= ation. If you have received this message in error, please delete it without= making any copies whatsoever and notify the sender. Thank you for your ass= istance. --_000_254bc57bf034482aa0e1357221ce96b6suvach_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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_sett= ings.

 

(postgres@[local]:55000)[postgres]&g= t; 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 '(d= atestyle|intervalstyle|timezone)'

datestyle =3D 'iso, mdy'

#intervalstyle =3D 'postgres'

timezone =3D '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&uu= ml;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 n= amed above. It may contain confidential or legally protected data or inform= ation. 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.
--_000_254bc57bf034482aa0e1357221ce96b6suvach_-- ------D8DE5AE6C5AE25B746C8B784BAD61A14 Content-Type: application/pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" MIIW8AYJKoZIhvcNAQcCoIIW4TCCFt0CAQExDTALBglghkgBZQMEAgEwCwYJKoZI hvcNAQcBoIITMTCCBWAwggNIoAMCAQICFHhYXy6tLBlL4zcHNTQTKLWW1GWTMA0G CSqGSIb3DQEBCwUAMEgxCzAJBgNVBAYTAkJNMRkwFwYDVQQKExBRdW9WYWRpcyBM aW1pdGVkMR4wHAYDVQQDExVRdW9WYWRpcyBSb290IENBIDEgRzMwHhcNMTIwMTEy MTcyNzQ0WhcNNDIwMTEyMTcyNzQ0WjBIMQswCQYDVQQGEwJCTTEZMBcGA1UEChMQ UXVvVmFkaXMgTGltaXRlZDEeMBwGA1UEAxMVUXVvVmFkaXMgUm9vdCBDQSAxIEcz MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAoL5QEI7p8mxAtASchbkx ytwt5BGpBDwbVcHnWDAdJLTD74XejCzhwT3fguZPrUeHbOxbScFK1buP7Iesf4Ka huw9A5lSAdI1nqza8FPJZjzUrAIB2iTTO6gCRq+kHOP4c1h2t/YOkA218M/M+vnG TOXDhjAKjRd+NevF37sOnMCNh+OIOIVn+j7Hq+ATnAUYmM+T9bGStPwj08/VxCdJ 4J48mwiji10qIeD8OapT2n1+zxoJU7xdBQTPoUqPi3aCDaH40scUd1uQNgeBmz4G +lJeY8WmAP6l6VIbUrWSOXIDCWK9sGAWbqbdJcIDZt3zBNFA4k6LhvRv5YOgJ4Re BMH1kL0wPcTvqGm8OJukpJbRYtppwAGWrsvEUTTqDKr/IY5Zj0pc5GGap9LpKniN UT06Fe6iWY6pXN7F+ZAi5YhFcd2RmWx6nz09mHxe9r4WaKBergsj/FoPqiJ2Lcmh EB3k00QjkIifxirm1/Was1geLzCJCBtUorWYI+wIdxyVXWHRy4mcX6JKkZrvIapJ FgiovWEoMcl0rYX22cWxi9HlEDJNX4sgOjxJHzOFWQ3bywl1Q2lz+2txffDfxEx9 xqMuyJV5y3Oijk5NJPte5AS+chumJy1JWpl611wJILd/lLlP8Q0cXohCGxG355Hb nmz0at+MBpgDrcwo76VH81MCAwEAAaNCMEAwDwYDVR0TAQH/BAUwAwEB/zAOBgNV HQ8BAf8EBAMCAQYwHQYDVR0OBBYEFKOX1vNeohDhq0WfPBdkPO4BcJzMMA0GCSqG SIb3DQEBCwUAA4ICAQAY+lt1/D56x193x8rfz1/DEsRAXdQyqrhq19UVFUaYI6Xm kFsYmUzjrUKjgjE2iM3p+8QElkiLAceNAc9bMwaWRmZ0HU/twba5tA1hzGN+1y53 jJYcKiNoa4VXdnAzE/7hT6Yjdxj6GozovWXJzz/0yRfc68e8wAQuLUYvaWbDG4/+ 7D7TypS/dgolDal7Ahyp0DtfC8CBOj1k4b+nLU69TcTYKcYiGNDFrHICgj+qOqI6 Ipcx3Qhjw3UUuWAoLVto4BapZoIjUfXrU9gxm3vpt51L64gWz/ldOIpJMI/t8esZ 9HcaMRhNZ1RsL29l+ds97CHsXvT0i8pgZVTRcWT0+aajgTM2M3HwpHhfTq2DId40 SY3oWayd8nZaNvIT9K/gCcdhKmz34J2uu4ZKKG8u7rR5zZAzw7N2+vXwbJ0BkPqe kPaccs9H2sMf5DUgU/JU0d9hg6YC4iU43oUyLV5zkFJdQsTOPUvh+RmEHdWiUMxB +0EUw73WyVqjY2YCgL0FOjtHnOwAJkz1iFG/qCN/GAewC+2LJqFk02FK61yf3rOv ZwOzH91tXWloaateOux8abzHO4VOnhW5tBVPw5V6WNfJbOlsufMpY160LPAtPe1a ZeCpW0DCSJmBbZ4fBio8ErSLD5uiJPCmjdZ64Eu2ZJZjlYTCSs0cLiSHM2DlwzCC BrswggSjoAMCAQICFHvcu2/NTQIZyH1IefT01xW2uDSuMA0GCSqGSIb3DQEBCwUA MEgxCzAJBgNVBAYTAkJNMRkwFwYDVQQKExBRdW9WYWRpcyBMaW1pdGVkMR4wHAYD VQQDExVRdW9WYWRpcyBSb290IENBIDEgRzMwHhcNMjAwNzIyMTgyNTQ2WhcNMzAw NzIwMTgyNTQ2WjBdMQswCQYDVQQGEwJDSDEmMCQGA1UECgwdUXVvVmFkaXMgVHJ1 c3RsaW5rIFNjaHdlaXogQUcxJjAkBgNVBAMMHVF1b1ZhZGlzIFN3aXNzIEFkdmFu Y2VkIENBIEc0MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAlggi5qpD XEgmsEKQF8LOwgCjxA6rO2OdkwRNj9BZFWGjbZxchvrXuJFifJe/NlV8qN2byo8J 1GGxy66wN2NypVF7xsBQ7xqVSW051R535t+xDsaaCrvPYuT+AOdJSDdaDZxsxZG1 ksy4IGfFt+Cs+wDvG9gPo+9jkooB/dJhOmQoB8+cfnFAZoq7SraHZHcIDVDIzh3S kJen+3rZuuTH8V7URR2fgB4d/ueY0KxlikWS4tUu63MWNXWkW0gAzcpkbdqwv37R aZzmbhfEOZyRSDGYyMyMPjPSaN33u9y01aCsz8fubZPFCV2ebrLGjzFpi+VZ8KQN DX80vqXkAjW+j9I6RtgUvWCmW6BQ29fs1NI5dDXQOqZkkfteMIilHX4Wk0FZlDgD ZuKbEJE9J7wTOCSJ8UmvIPbjpH+ldbTRE4tT7bd6IB5/z1lEri4NBpFs90sfBugv 0t8RFOYv78x3sYQWpFDcItGEOnSv8ApzzVK/w8DAMDuMkrWnS6fN/wXnp92a7wgf guO/6BCKEUD6Db/nUFJnaPhRWEoD/QmpbTGcVbpiDKnuFjR8xG5gKboLnOqF4dlb 3M3CB9b7VuIgRqRM/3bi3eoCs3x1DGAePeuFqpMBO7gXPE9vfMpfMIJit6RgK8Wn kzPoRxsQcsATt8nxB0onwBa/d6KUKSdtyVsCAwEAAaOCAYYwggGCMBIGA1UdEwEB /wQIMAYBAf8CAQAwHwYDVR0jBBgwFoAUo5fW816iEOGrRZ88F2Q87gFwnMwwdAYI KwYBBQUHAQEEaDBmMDgGCCsGAQUFBzAChixodHRwOi8vdHJ1c3QucXVvdmFkaXNn bG9iYWwuY29tL3F2cmNhMWczLmNydDAqBggrBgEFBQcwAYYeaHR0cDovL29jc3Au cXVvdmFkaXNnbG9iYWwuY29tMEoGA1UdIARDMEEwPwYEVR0gADA3MDUGCCsGAQUF BwIBFilodHRwczovL3d3dy5xdW92YWRpc2dsb2JhbC5jb20vcmVwb3NpdG9yeTAd BgNVHSUEFjAUBggrBgEFBQcDAgYIKwYBBQUHAwQwOwYDVR0fBDQwMjAwoC6gLIYq aHR0cDovL2NybC5xdW92YWRpc2dsb2JhbC5jb20vcXZyY2ExZzMuY3JsMB0GA1Ud DgQWBBSVAeNZ11Vz5MI2Dag7kkvZ5h4QfjAOBgNVHQ8BAf8EBAMCAQYwDQYJKoZI hvcNAQELBQADggIBADcLOfFJ2NGTzyEok3BBFiw8Grw/YSYgSebJUTLCuYuP21nh Yr1fZSc66lYUVfPqNLIG7mPkwCXiqEusObswHmSBPlN0DyaPVid0Nc2fHnZ6577B XRADaa5YezjFllVh0Z3axKnIWg0MkxBigErA4cqJSLYbNMWQ/MY9xo70KeAlhIMS 4bYmwhGkqRN/HNSSRuFDUE5Ve8GoQLJZe12Wv8kCi5cxykMO09OsJOpICk9BmGOt AQbQ2wJLyu7z3M22GxAYhwjjVhGxttyKiybXOdD0Tn9EFyXO6CoblsX0qHHFg2kJ 5NpvFObo5ICLtkeGuTsNNVWf5+ItZqWQMLm2cZ43Rgle1qc+xlwsHME1JlysW78v iF4oefF/Afj1mh4kXTAa1CotrOysS/XMV+RKuwCrkuVbcApwhP7tpx9GlHK/U1tH gm9/z5hm7ED9hkIwIt9ZTlQoApvK6lJUTzzrM+jqJFPgWLOUG7n/rubEZao6k0NX Pm67CMlcsZTjqjkXeY55TZTN/LQmm+TlKZRWmZcswNWOfwHkYKvOdGAEZ+xJeA9D jBW3wOKpup/5pZywKJaYkQu+t/1lgfyWRI/KAB6HmNkWtACbrw1L8PHG5i68Km0T YVjsx7eZR51ixaq1CM53gFYhY8lXvU4jhAfqpvpZEC8tJxtxH+9WrxdvPiJvMIIH CjCCBPKgAwIBAgIUR4nN4jOe4pgDLTub571PxfpJgzwwDQYJKoZIhvcNAQELBQAw XTELMAkGA1UEBhMCQ0gxJjAkBgNVBAoMHVF1b1ZhZGlzIFRydXN0bGluayBTY2h3 ZWl6IEFHMSYwJAYDVQQDDB1RdW9WYWRpcyBTd2lzcyBBZHZhbmNlZCBDQSBHNDAe Fw0yMDEyMTAyMzIzNDZaFw0yMzEyMTAyMzMzMDBaMIGDMQswCQYDVQQGEwJDSDEP MA0GA1UECAwGTHV6ZXJuMQ8wDQYDVQQHDAZMdXplcm4xDTALBgNVBAoMBFNVVkEx HTAbBgNVBAMMFFdpbGxpYW0gU2VzY3UgKFN1dmEpMSQwIgYJKoZIhvcNAQkBFhV3 aWxsaWFtLnNlc2N1QHN1dmEuY2gwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIK AoICAQC5g7K1xtsuuVja0Lq7IjCS19O1Jjn6DhQaWIjtnxH1g63wzuSBYPL1Rbz2 redxaR02/ck11gRhD6lpl/HmzbTDA4v5qc4moZ7M9fnjSGKo1N14HVohTiEdhOhj PO11b4aOi+BkqZzngX7q1g+pL+3UQvqtEb8rIrFGK2dN+VaiDxVhLc2vVSlfRNxc fVxH6IsIr6nyxC0gjxyIzd4UsCrlokFcHsiEHv4CAVMckHO2t9r5XoYJMdFAfsG9 3UzmAntRniI61MWuHurf45NK6mmbb7HIU0L3yrdV9Sgr0MgmpQzXRDuxlE1hC9Zs u8HDW4Rr5//4RbjBj0aM6zaTFhlgM5rUtKRgcFFQ3uu1q5dLuod9KYqttlatj0Mz alLFEuw0DLgmLWVtUWMyK57iHYCuUuHKk0PEyl0I3th291Ynp/VRsNp3sn+UKvjm +mr1sIrrFvilJNBoEnWMbHCKWWCMB6rnRwcR/GuYUCIYuFMKfRPprJUZEYQioAi1 fvxly19IMbYssNYT60ZU3R9+1KHQmfZOW/KjSRrACjrPkRnLQbT+4rEDEU6Xb9K0 YCOuNnfo01GUHRga6N4SeE5O9kjid7oCWDzrZKDqHqMvCiL9yHUYdxQe8weuudjS t66Viq6+yLUf3s9UeWxH1bStY3p/UbW3MFHs3ZTP6KI1m6WdIwIDAQABo4IBmTCC AZUwHwYDVR0jBBgwFoAUlQHjWddVc+TCNg2oO5JL2eYeEH4wgYUGCCsGAQUFBwEB BHkwdzBJBggrBgEFBQcwAoY9aHR0cDovL3RydXN0LnF1b3ZhZGlzZ2xvYmFsLmNv bS9xdW92YWRpc3N3aXNzYWR2YW5jZWRjYWc0LmNydDAqBggrBgEFBQcwAYYeaHR0 cDovL29jc3AucXVvdmFkaXNnbG9iYWwuY29tME4GA1UdIARHMEUwQwYJKwYBBAG+ WAFkMDYwNAYIKwYBBQUHAgEWKGh0dHA6Ly93d3cucXVvdmFkaXNnbG9iYWwuY29t L3JlcG9zaXRvcnkwHQYDVR0lBBYwFAYIKwYBBQUHAwIGCCsGAQUFBwMEMEwGA1Ud HwRFMEMwQaA/oD2GO2h0dHA6Ly9jcmwucXVvdmFkaXNnbG9iYWwuY29tL3F1b3Zh ZGlzc3dpc3NhZHZhbmNlZGNhZzQuY3JsMB0GA1UdDgQWBBS5hbq1asNYsU5SQuim TeTpQz4sczAOBgNVHQ8BAf8EBAMCBaAwDQYJKoZIhvcNAQELBQADggIBAEYRQLnA kbuQuZPQS+CUbM8+txubo6Gk0ud2cvMsGpOLJyow7Wubc93fpK+FOLFoUfI839bR MRBThO6hlVDw5pV8IyDvZ6yBZuAd3cQ2rrya70c79rDO7HGxrI0H8g8uhtR76RmW hvBgaH74PKwLaZaD0NRb8bYnf4CU2l+Fbf3oblwCJ6Ej8CW/Al4l3eEFPdGEC5BQ yS9rvWLI8V7IOYM2q/Wx0ghhMWhWx0OCGDfmp667nloYIgMyweCpfHaI93Pm3zzW hxI2f31aLjZO5Nj760HlkI0uPBHXehylRnzCT+H9S5Xlq/uHg59qU6+BQRMPbhkd c1Iucw4oS2BlqlRYPhSh0hvDbab6K65CaN1hKp7Uza9shpKs5ZxUjYFPDRd548ru Q48ntoi+yCL4H01XUrW4/maSgiXsSMmxdAJudLuUBHzzAiBjD6pKQ4ZBsy/BipU5 as++n2RUJBf7XQVcroITSXq0eqADiESF84zo/sgUwk4X1ZGAr8jMiWFH1emyScgh tJTWpU2AtWC/FcuSgmpdPyoJ2QDrYKU5bhYgFIkGq/ZwqyO+P1NNKUmx0e6zrk5n RTB/yKsx01e3Q8t+W01UAXop+YDT0gNsRRpgXvTwyQTpAVWTN/PWQ4T+HBDqWBiK Jnn55I8A/d6SxRAN+LL2HpwISRDs/tJDpuJEMYIDhTCCA4ECAQEwdTBdMQswCQYD VQQGEwJDSDEmMCQGA1UECgwdUXVvVmFkaXMgVHJ1c3RsaW5rIFNjaHdlaXogQUcx JjAkBgNVBAMMHVF1b1ZhZGlzIFN3aXNzIEFkdmFuY2VkIENBIEc0AhRHic3iM57i mAMtO5vnvU/F+kmDPDALBglghkgBZQMEAgGggeQwGAYJKoZIhvcNAQkDMQsGCSqG SIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMjEwMTIwMDg1NjA0WjAvBgkqhkiG9w0B CQQxIgQg40A8sDZogqXma3Xpcs+yvN2b9biBobOHje2tohiryfAweQYJKoZIhvcN AQkPMWwwajALBglghkgBZQMEASowCwYJYIZIAWUDBAEWMAsGCWCGSAFlAwQBAjAK BggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4D AgcwDQYIKoZIhvcNAwICASgwDQYJKoZIhvcNAQEBBQAEggIAbzzEaX5++UD42Jpl 3eNl0hkS2zNj7BEvCux8Ybq0WZaMRYKAW5lCpwjmHJYOjbf8sibGaRPT6K/RVd3p RawDTkYHL0FOrPUnjiZHqxAngnaArm/wzuEYnK0ACnFMdRinVIv0ubPP5mBuQzeJ V90OzBA7J3lAqjoeUKUu/cmGXx6vDS8D6fbLDKYpIMbmPsg2Fcymld74XIP9zkCv bSm6Iuv2a8YFkGKiS8b7nyAIwOlzg1NBmsZUJSoiUUUcajc4SFxzCe5GvTz8yku8 T7WqSoBTDG+CIPaGRx0h56hJ6yzP4ym1mz5h3ne+rKQjaTE7Fiaw3aEtAlAzH1AA wfQ1fqVmRryGY/syVC2SpO2XzfyY4nRxaEPbw2OGJvghh32QRvGzcaxNhnVIj3/H 8R3Dj0Rx75N/5f8JRU4Ve+J7U6Wz8AGnISPjfmfyoxSyfPNTWAlBYliQy+kaa5QG 2xrlI6h2q5mEM1+OBVK2QdRZqaTmWlHzr4lM/hVmP189dJpwMMlH9BIrMMApK711 eAfQTdV1gOLEjq+l+L4ADgVQoxEdsCrC4SQtuEpJu/Phft2o8B+tzyGOqpe2EsVi 2fjCprdutkokJEG/i6EfEOGEVMVfsQ5bexjZMdS2FvQ/H02KCUVCSjMKlvlrILQW ONdg4vhCF0V0FLa1Bd5bAGO89a4= ------D8DE5AE6C5AE25B746C8B784BAD61A14--