Re: Timezone for %t log_line_prefix

Andrew Dunstan <andrew@dunslane.net> writes:
> Andreas Pflug wrote:
>> If %t is used in log_line_prefix, win32's strftime will print a very 
>> long timezone information, e.g. "W. Europe Daylight Time" where Linux 
>> would write "UTC". This makes the timestamp consuming more than half 
>> of an average line length.
>> Do we have alternatives to the long form? Do we need the timezone 
>> information at all? We know already it's the server's time. Another 
>> alternative would be a short timestamp (%t vs. %T) to have both.

> That's ugly, and unfortunately %z is GNU-specific.

Does Windows' strftime have any short zone name %-spec?  Seems like a
quick #ifdef WIN32 to use a more compact zone name would be the best
solution.

I'd be inclined to leave out the zone field *on Windows only* if there
is no %-spec that uses something more reasonable.  I don't think this
problem justifies adding more %-options to log_line_prefix.
        regards, tom lane