Re: [HACKERS] tzdata issue on cross-compiled postgresql

2008-01-09 Thread Tom Lane
"Tim Yardley" <[EMAIL PROTECTED]> writes: >> Can you strace the backend while it's doing this and see if there's a >> difference in the series of kernel calls issued? > See attached strace. Let me know if you see anything enlightening. Nope :-(. The strace output is *exactly* the same across al

Re: [HACKERS] tzdata issue on cross-compiled postgresql

2008-01-09 Thread Tom Lane
"Tim Yardley" <[EMAIL PROTECTED]> writes: > postgres=# select count(*) from pg_timezone_names where utc_offset != '00:00'; > count > --- > 0 > postgres=# select count(*) from pg_timezone_names where utc_offset != '00:00'; > count > --- >504 > postgres=# select count(*) from pg_ti

[HACKERS] tzdata issue on cross-compiled postgresql

2008-01-09 Thread Tim Yardley
Hackers; I've noticed a strangeness on our cross-compiled uclibc linked postgresql package that I was hoping to elicit some help with. This is probably best described by showing some queries with commentary, so on with that. postgres=# select count(*) from pg_timezone_names where utc_offset != '