With Shakespearian flourish, "Thomas G. Lockhart" writes:
> [timezone problems with AIX 3.2.5]
> I'm not aware of other USE_POSIX_TIME/!HAVE_INT_TIMEZONE machines seeing
> this problem. Is AIX4.1 in that same features category?
No, it's not, as it supports a valid INT_TIMEZONE. Actually, I've been
removing USE_POSIX_TIME under AIX 3.2.5, since USE_POSIX_TIME/!INT_TZ
doesn't work for AIX either -- that falls back to using tm_gmtoff and
tm_isdst element to struct tm that are not available under AIX. So
the code I've been hacking at is the !USE_POSIX_TIME code (or, as
I've made it, the use-timezone-info-but-avoid-int-timezone code).
Ohhhhh crap. I just discovered the problem. I can't believe I didn't
hit this in my tests before.
AIX 3.2.5 does have a happily valid int timezone. Works fine. Until
you link with the BSD library. At which point it comes out hugely
negative (and time-travels your dates 25 years west of GMT.)
I haven't tested this with PostgreSQL itself yet, but I just compiled my
check-code without -lbsd and everything seems to have worked 100% fine.
If that works for the database, all we should need to do is rip out -lbsd.
> I thought that AIX3.2.5 has _some_ timezone support; if not then you
> really are the only machine I've found other than NextStep which is in
> that category.
It seems to have _SWITCHABLE_ POSIX/BSD timezone support (instead of just
letting them live happily together). Very strange. But I even found this
to be true in a little 20-line test program I put together. Which I've
just upgraded to AIX 4.1, and seems to show the same problem. I guess
maybe we use -lbsd for 3.2.5 and don't use it for 4.1? Hm. Otherwise
this should have showed up under AIX 4.1, too -- at least, it did when
I tested on the one AIX 4.1 system I have access to.
Regardless, compiling without -lbsd now. I'll let you know.
<fingers crossed>
-Frank
- --
Frank R. Dana, Jr. Senior Associate Programmer
danaf@ans.net ANS Communications
(914) 789-5449 100 Clearbrook Rd. Elmsford, NY 10523
Pager: 800-946-4646 pin# 1420717
------------------------------
