| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Timezone for %t log_line_prefix |
| Date: | 2004-08-04 20:37:45 |
| Message-ID: | 41114919.5060700@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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. The quick fix for now
does seem to be providing alternative forms - %T and %S make sense. Of
course, if we wanted it *really* short we could just print out the
current epoch time in 8 hex digits :-)
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Gardner | 2004-08-04 20:47:38 | Re: Updateable Views? |
| Previous Message | Tom Lane | 2004-08-04 19:33:15 | Re: 7.5 backend crash |