Re: Timezone for %t log_line_prefix

Started by Magnus Haganderover 21 years ago2 messages
#1Magnus Hagander
mha@sollentuna.net

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.

No. This is what the cruft in pgtz.c (TZABBREV macro and associated
function) was all about.

//Magnus

#2Magnus Hagander
mha@sollentuna.net
In reply to: Magnus Hagander (#1)

Since we do have control over the timezone library now, one possible
answer is to extend the src/timezone API so that it's possible to
convert/format against more than a single timezone. We could then
remember the zone setting inherited from the postmaster and always use
that when formatting timestamps for the log, while not changing the
behavior for operations at the SQL level.

Time permitting, I was planning to address this in 8.1. (well, 7.6 then,
but I guess it's 8.1 now). Not specificalyl the issue, but the
groundwork API change to make it possible.

However, this is probably a bit more work than is reasonable to
undertake right now, when we're already overdue for beta.

Definitly.

//Magnus