Re: Problem with 7.3 on Irix with dates before 1970

"Robert E. Bruccoleri" <bruc@stone.congenomics.com> 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