"Robert E. Bruccoleri" <[EMAIL PROTECTED]> writes: > There are differences in the regression tests for PostgreSQL > 7.3b2 with handling of times before 1970. I recently sent out a set of > diffs for the changes. I've looked through the datetime.c code, but > it's not obvious to me what the cause of the change is. PostgreSQL 7.2 > works fine on Irix for these cases.
Waitasec ... are you using src/include/port/irix5.h as the port-specific config file? (Check the symlink src/include/pg_config_os.h to find out.) If so, try removing "#define NO_MKTIME_BEFORE_1970" from irix5.h and see if things get better. I asked awhile ago if that symbol was still needed given the mktime workaround, but no one got back to me on it. My current theory is that once you remove that symbol, you will get results matching the Solaris expected files --- ie, I suspect that your system believes there was DST in 1947. Do you have a way of verifying that theory by looking at the system timezone database? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]