Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 24CDA9F93A2
	for <pgsql-docs-postgresql.org@postgresql.org>;
	Sat, 23 Dec 2006 05:42:01 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 16520-01 for <pgsql-docs-postgresql.org@postgresql.org>;
	Sat, 23 Dec 2006 05:41:55 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192])
	by postgresql.org (Postfix) with ESMTP id 0CBB29F939F
	for <pgsql-docs@postgresql.org>; Sat, 23 Dec 2006 05:41:54 -0400 (AST)
Received: from sd-2317.dedibox.fr (localhost.localdomain [127.0.0.1])
	by sd-2317.dedibox.fr (Postfix) with ESMTP id 70715BABD
	for <pgsql-docs@postgresql.org>; Sat, 23 Dec 2006 10:41:51 +0100 (CET)
Received: from [192.168.10.64]
	(ASte-Genev-Bois-153-1-3-137.w83-112.abo.wanadoo.fr [83.112.65.137])
	by sd-2317.dedibox.fr (Postfix) with ESMTP id 21C4CBAAA
	for <pgsql-docs@postgresql.org>; Sat, 23 Dec 2006 10:41:51 +0100 (CET)
Message-ID: <458CF9E2.5070403@lelarge.info>
Date: Sat, 23 Dec 2006 10:41:54 +0100
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Thunderbird 1.5.0.8 (X11/20061115)
MIME-Version: 1.0
To: pgsql-docs@postgresql.org
Subject: Re: DateStyle config variable
References: <45899637.5020608@lelarge.info>
In-Reply-To: <45899637.5020608@lelarge.info>
Content-Type: multipart/mixed; boundary="------------060605000703000102020004"
X-Virus-Scanned: ClamAV using ClamSMTP
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/172
X-Sequence-Number: 4095

This is a multi-part message in MIME format.
--------------060605000703000102020004
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

Guillaume Lelarge a écrit :
> I wondered if there was a reason for the mixed case capitalization of
> the DateStyle setting ? all other settings are in lowercase. Even
> DateStyle is in lowercase in the postgresql.conf file.
> 
> If there's none, here is a patch (CVS HEAD) to put it in lowercase.
> 

Sorry, I forgot to add the patch... :-/

Regards.


-- 
Guillaume.
<!-- http://abs.traduc.org/
     http://lfs.traduc.org/
     http://docs.postgresqlfr.org/ -->

--------------060605000703000102020004
Content-Type: text/plain;
 name="datestyle.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="datestyle.patch"

Index: src/sgml/config.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/config.sgml,v
retrieving revision 1.99
diff -u -3 -p -r1.99 config.sgml
--- src/sgml/config.sgml	12 Dec 2006 21:30:33 -0000	1.99
+++ src/sgml/config.sgml	20 Dec 2006 19:54:00 -0000
@@ -3491,10 +3491,10 @@ SELECT * FROM parent WHERE key = 2400;
 
      <variablelist>
 
-     <varlistentry id="guc-datestyle" xreflabel="DateStyle">
-      <term><varname>DateStyle</varname> (<type>string</type>)</term>
+     <varlistentry id="guc-datestyle" xreflabel="datestyle">
+      <term><varname>datestyle</varname> (<type>string</type>)</term>
       <indexterm>
-       <primary><varname>DateStyle</> configuration parameter</primary>
+       <primary><varname>datestyle</> configuration parameter</primary>
       </indexterm>
       <listitem>
        <para>
Index: src/sgml/datetime.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/datetime.sgml,v
retrieving revision 2.55
diff -u -3 -p -r2.55 datetime.sgml
--- src/sgml/datetime.sgml	17 Oct 2006 21:03:20 -0000	2.55
+++ src/sgml/datetime.sgml	20 Dec 2006 19:54:00 -0000
@@ -143,7 +143,7 @@
       <step>
        <para>
         Otherwise the date field ordering is assumed to follow the
-        <varname>DateStyle</> setting: mm-dd-yy, dd-mm-yy, or yy-mm-dd.
+        <varname>datestyle</> setting: mm-dd-yy, dd-mm-yy, or yy-mm-dd.
         Throw an error if a month or day field is found to be out of range.
        </para>
       </step>
Index: src/sgml/libpq.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/libpq.sgml,v
retrieving revision 1.221
diff -u -3 -p -r1.221 libpq.sgml
--- src/sgml/libpq.sgml	19 Dec 2006 01:53:36 -0000	1.221
+++ src/sgml/libpq.sgml	20 Dec 2006 19:54:02 -0000
@@ -885,7 +885,7 @@ Parameters reported as of the current re
 <literal>client_encoding</>,
 <literal>is_superuser</>,
 <literal>session_authorization</>,
-<literal>DateStyle</>,
+<literal>datestyle</>,
 <literal>TimeZone</>,
 <literal>integer_datetimes</>, and
 <literal>standard_conforming_strings</>.
Index: src/sgml/protocol.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/protocol.sgml,v
retrieving revision 1.66
diff -u -3 -p -r1.66 protocol.sgml
--- src/sgml/protocol.sgml	6 Sep 2006 20:40:47 -0000	1.66
+++ src/sgml/protocol.sgml	20 Dec 2006 19:54:02 -0000
@@ -1050,7 +1050,7 @@
     <literal>client_encoding</>,
     <literal>is_superuser</>,
     <literal>session_authorization</>,
-    <literal>DateStyle</>,
+    <literal>datestyle</>,
     <literal>TimeZone</>,
     <literal>integer_datetimes</>, and
     <literal>standard_conforming_strings</>.
Index: src/sgml/release.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/release.sgml,v
retrieving revision 1.488
diff -u -3 -p -r1.488 release.sgml
--- src/sgml/release.sgml	2 Dec 2006 00:46:46 -0000	1.488
+++ src/sgml/release.sgml	20 Dec 2006 19:54:04 -0000
@@ -1438,12 +1438,12 @@ links to the main documentation.
        <para>
         Make <link linkend="APP-INITDB"><application>initdb</></link>
         detect the operating system locale and set the default
-        <varname>DateStyle</> accordingly (Peter)
+        <varname>datestyle</> accordingly (Peter)
        </para>
 
        <para>
         This makes it more likely that the installed
-        <filename>postgresql.conf</> <varname>DateStyle</> value will
+        <filename>postgresql.conf</> <varname>datestyle</> value will
         be as desired.
        </para>
       </listitem>
Index: src/sgml/ref/copy.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v
retrieving revision 1.77
diff -u -3 -p -r1.77 copy.sgml
--- src/sgml/ref/copy.sgml	18 Sep 2006 19:54:01 -0000	1.77
+++ src/sgml/ref/copy.sgml	20 Dec 2006 19:54:04 -0000
@@ -346,10 +346,10 @@ COPY <replaceable class="parameter">coun
 
    <para>
     <command>COPY</command> input and output is affected by
-    <varname>DateStyle</varname>. To ensure portability to other
+    <varname>datestyle</varname>. To ensure portability to other
     <productname>PostgreSQL</productname> installations that might use
-    non-default <varname>DateStyle</varname> settings,
-    <varname>DateStyle</varname> should be set to <literal>ISO</> before
+    non-default <varname>datestyle</varname> settings,
+    <varname>datestyle</varname> should be set to <literal>ISO</> before
     using <command>COPY TO</>.
    </para>
 
Index: src/sgml/ref/show.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/show.sgml,v
retrieving revision 1.42
diff -u -3 -p -r1.42 show.sgml
--- src/sgml/ref/show.sgml	16 Sep 2006 00:30:20 -0000	1.42
+++ src/sgml/ref/show.sgml	20 Dec 2006 19:54:04 -0000
@@ -138,11 +138,11 @@ SHOW ALL
   <title>Examples</title>
 
   <para>
-   Show the current setting of the parameter <varname>DateStyle</varname>:
+   Show the current setting of the parameter <varname>datestyle</varname>:
 
 <programlisting>
-SHOW DateStyle;
- DateStyle
+SHOW datestyle;
+ datestyle
 -----------
  ISO, MDY
 (1 row)

--------------060605000703000102020004--