Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > However, I actually prefer the mail header style of timezone to EST/EDT
> > anyway:
> 
> Agreed, but AFAIK there's no portable way to ask strftime for that,
> so you're still stuck with a compatibility problem.  We could teach
> pg_strftime to do it, but that's something for 8.1 or beyond.

OK, the attached applied patch suppresses timezone output from
log_line_prefix %t on Win32.   Also added to TODO:

        Win32

        o Re-enable timezone output on log_line_prefix '%t' when a
          shorter timezone string is available


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [EMAIL PROTECTED]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
Index: src/backend/utils/error/elog.c
===================================================================
RCS file: /cvsroot/pgsql-server/src/backend/utils/error/elog.c,v
retrieving revision 1.152
diff -c -c -r1.152 elog.c
*** src/backend/utils/error/elog.c      7 Oct 2004 15:21:54 -0000       1.152
--- src/backend/utils/error/elog.c      9 Oct 2004 01:21:37 -0000
***************
*** 1391,1397 ****
--- 1391,1402 ----
                                        char            strfbuf[128];
  
                                        strftime(strfbuf, sizeof(strfbuf),
+                                       /* Win32 timezone names are too long so don't 
print them. */
+ #ifndef WIN32
                                                         "%Y-%m-%d %H:%M:%S %Z",
+ #else
+                                                        "%Y-%m-%d %H:%M:%S",
+ #endif
                                                         localtime(&stamp_time));
                                        appendStringInfoString(buf, strfbuf);
                                }
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to