Re: BUG #2816: Logfile difference in timestamp between - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #2816: Logfile difference in timestamp between
Date
Msg-id 200612122131.kBCLVCV27592@momjian.us
Whole thread Raw
In response to Re: BUG #2816: Logfile difference in timestamp between Windows and Linux  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:
> "Joost Karaaijeveld" <J.Kraaijeveld@Askesis.nl> writes:
> > Printing a timestamp using '%t%' in Windows omits the timezone in the
> > logfile. In Linux the timezone is printed. Either make the two the same by
> > default or make it configurable so that the user can make them the same.
>
> The zone name available from Windows is not only too long, but
> localized, and we can't be sure that it's given in the right encoding.
> So I'm afraid this isn't happening.

Seems this was not documented, so I added a mention and backpatched to
8.2.X.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
Index: doc/src/sgml/config.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/config.sgml,v
retrieving revision 1.98
diff -c -c -r1.98 config.sgml
*** doc/src/sgml/config.sgml    30 Nov 2006 20:50:44 -0000    1.98
--- doc/src/sgml/config.sgml    12 Dec 2006 21:21:57 -0000
***************
*** 2803,2809 ****
              </row>
              <row>
               <entry><literal>%t</literal></entry>
!              <entry>Time stamp (no milliseconds)</entry>
               <entry>no</entry>
              </row>
              <row>
--- 2803,2809 ----
              </row>
              <row>
               <entry><literal>%t</literal></entry>
!              <entry>Time stamp (no milliseconds, no timezone on Windows)</entry>
               <entry>no</entry>
              </row>
              <row>

pgsql-bugs by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: postgresql installation on centOS not working
Next
From: Tom Lane
Date:
Subject: Re: ERROR: failed to build any 4-way joins