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/ -->
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)